VB Forum / Database Access / January 2004

Suppose I have a Database 'db' (x.mdb) and a filtered recordset 'rs' (select
* from myTable where .....)
How can I COPY all data from rs to a new table 'newtbl' in a new database
'newdb.mdb' ???

I have a form where people log what work has been done and the problem
occurs after midnight as we require them to log that job to the day before
not the new date after mid night.
my date field is at the bottom of the form so I thought if I used a 'on

H
reg MS-Access200
Can I make one of my own tables look like a system object when opening Db via MS-Access  ?
and/Or can i create ABSOLUTELY invisible tables

I am trying to execute an SQL query using the Office Web Components control.
I have never used this before and this is what I have so far:
PivotTable1.DataSource = ctlDataSrc
PivotTable1.ConnectionString = "DSN=rtecompaq"

it seems the following code sucks up all the memory available, after
some hours in fact my application hangs while windows shows
memory extension alerts. (it takes up to 70 mb)
I've tried to replace the entire code below with a simple loop without

Is there any way to find out if a database is open or running and then run a
program based on the result?
Thx

I am trying to Seek thorough a database using code similar to this:
Dim myDB As Database
Dim myRS As Recordset
Set myDB = OpenDatabase("file.mdb")

I wonder if some one could please help me with a problem I have regarding a
database.
I am trying to write an appointment program for a friend and I need a little
assistance.

in my application i did a table transfer . source table is in the oracle
data base and the target table is in ms sql 2000.
i have to transfer million records from source to destination
the following error i got

When using the .update methad in DAO 3.6 is there a way to find out why
access has aborted the save. I get an error saying that an external
application has stopped the process..
Chris Radulich

H
Can anyone tell me how I can check if an ADO RecordSet is open
TI
Dave

Hi,
My issue is similar to many already posted but still unanswered. (sic)
Developers have Excel VBA code to update Team Leader's mpp file. Developers do not have Project OLE DB Provider in their machines.
How can I install it?

I am facing problem with code below, for uploading of file with more than 1MB of data on a remote web server(file with less than 1MB of data are being transferred), the code below works fine when i try to upload the same file on local webserver with any amount of data, there is ...

I have a database with records that all have a date-stamp. I need to be able
to produce stats on the number of records per week, that kind of thing. How
can I get a count of records per calendar week when they all have randomish
dates? Dont necessarily need code, just a high level ...

I have some problems when opening an ADO connection to an Access 2 database.
This is what happens:
I open the database using Access 2. Then I open the same database in VB6
using ADO: