Delete records from one database and save in another

[timfost]

Folks,

I am quite new with access so please bear with me. The situation is as follows. I have a database with four transaction tables. I wish to delete all records in these tables that have a date before 01-oct-2006 and at the same time copy them to another database as a sort of backup. What would be the quickest way to do this. I could just take a copy of the database and delete all records added after 01-oct-2006 and then delete the unwanted records from the original but want to make better use of access than this manual workaround.

thanks

 

[Remou]

Using the Query Design Window, it is possible to create an Append query that appends the data to a table in another (external) database.