Moving selected records from source database to archive database

[rk1_23]

Hi All,
i have Access DB with 4 tables interelated with 1 primary field, some flags common to all.
by checkin a flag- if all the 4 tables have inactive flag then i need to move to archive database from source database and delete it from Source.
can anyone suggest me how to move records from one DB to other DB using .net vs2005
Thanks in advance
Riya

 

[Pat Hartman]

You will need to use ADO. You'll need a query that identifies which ID has inactive records in all tables. Then a code loop to read through that recordset and for each row run a query for each table that copies from A to B and then another query to delete from A. If you were looking for a panacea, there isn't one.