how toCode the VB to do backup data base

[ph52]

Can any one give me sample of VB6-Coding to backup the selected row from a Tabel_A of DataBase DB1.MDB to the other Tabel_A in the other DB2.MDB

 

[Andrzejek]

Two ADODB connections: one to DB1.MDB, another one to DB2.MDB

str = "SELECT abc FROM Table_A WHERE... "
rst.Open str, [blue]CnnDB1[/blue]

str = "INSERT INTO Table_A (abc)"
[blue]CnnDB2[/blue].Execute str

Have fun.

---- Andy

 

[SBerthold]

Use the IN section of a INSERT INTO sql Statement:

INSERT INTO Tabel_A
IN '' [;DATABASE=C:\MyDBs\DB2.Mdb;]
SELECT * FROM Tabel_A

 

[SBerthold]

But, looking again at the thread title, why not just copy the complete MDB file?