Automatically transferring table information across mdbs

[adrift]

I've got a database of active patients with several tables. I want to be able to add a discharge function that automatically transfers discharged patient data to a new database and deletes data from the current database. This would include all data that matches the patient identifier.

The discharged patients database would have identical table design as the current database.

Is there code that will scan each table, pull out relevant records and transfer them to a different MDB?

Thanks, Shawn

 

[jebry]

Hi Shawn!

Once you have your db to hold the information on the discharged patients, you will need to link to the table in that db from you main db. You do that by clicking new table and choosing Link Table. Access will open a file browser and you can find your other db and choose the table to link to. Once you have created the link, you can use the other table as if it where in you main database. So all you will need to do is set up two action queries, the first to append the appropriate records to the linked table and the second to delete the same records from the main table.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[adrift]

brilliant, thank you jeff.