Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Moving records between two Access databases

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-09 : 09:23:58
Steve Crookes writes "Let me set the scene

Live Database with a set of tables
Archive database with an equivalent set of tables.
Corresponding tables have exactly the same Structure.

I am searching for a method of moving data between these databases without writing numerous lines of code.

It has been recommended to me that using class files as an intermediate step would be a solution. I agree that it would be a solution, but it is code heavy and does not take into account potential table changes in the table structures in the future.

I have been looking at using multiple recordsets to move the data but have so far not had any success.

Can you help!"
   

- Advertisement -