How dor you archive selected records to another database

[Andrew T]

I have a prospects database in Access 2000. This uses related tables in a one to many capacity. I need to archive old prospects to another access database that has an identical structure. I can't find out how to archive selected, related records either under programme control or otherwise. Can anyone help please

 

[John Nurick]

Hi Andrew,

Use File|Get External Data|Link to create linked tables in the working
database that are connected to the corresponding tables in the archive
database. Then use append queries to copy the data to be archived, and
finally delete queries to delete it from the working database.

Unless you have very large volumes of data it's often simpler to leave
all the data in one place, and use queries to display only the current
data to the user. Sometimes all this needs is appropriate date criteria
on your queries; sometimes it requires adding a yes/no field called
(e.g.) "Current" to the relevant tables.