fast way to append records in access mdb in a server dir

[sal21]

I have 2 database db1 and db2
db1 is in c:\mydir
db2 in server dir \\myserverdir

the 2 databse have a table named TABLE1 with the same fields and property.

I need to append (witha select sql) data from db1 to db2....

Wath is the best way based speeding and best performance?

I use vb6 and ado ject.

[HansV]

You can create a link in either of the databases to the table in the other one. You can then treat the linked table as a local table.

[sal21]

You can create a link in either of the databases to the table in the other one. You can then treat the linked table as a local table.

just i have think this way....sure.
But the db1 is on a Pc client and not every day is on line:-(

[HansV]

You won't be able to run the query if the PC is not online, of course. But as long as you don't try to run the query (or open the linked table), you won't get an error message.

[sal21]

You won't be able to run the query if the PC is not online, of course. But as long as you don't try to run the query (or open the linked table), you won't get an error message.

OK! but in otrher case how about:

Code: Select all

    SQL = "INSERT INTO TABEL2 IN \\MYSERVER\DB2.mdb SELECT * FROM TABEL1 WHERE AGG=#" & Format(LAST_DAY, "MM/DD/YYYY") & "#"
OCONN.Execute (SQL), CONTA, adCmdText Or adExecuteNoRecords

[HansV]

That should work, but again only when the PC is connected to the network.

[sal21]

That should work, but again only when the PC is connected to the network.

Naturally when the PC is connected... but i have forgotten a part mosst important in my post
I run the code from other project in vb6, and naturally the pc is Conected

In other case after the first test with the last code have error in "insert into..." have idea?

[HansV]

You should enclose the database name in single quotes:

SQL = "INSERT INTO TABEL2 IN '\\MYSERVER\DB2.mdb' SELECT * FROM TABEL1 WHERE AGG=#" & Format(LAST_DAY, "MM/DD/YYYY") & "#"