Creating a copy of records between databases

[andrewosborne]

Hi everyone, I am new to Access and this is my first post on the forum and I'm hoping you can help with a problem.

I have a large database with a table in it called casemaster. This table contains a large number of individual cases that have been either completed or are outstanding. I would like to copy the records for outstanding cases from this database to another database called Reports.

I have linked the casemaster table in to the other database and created a make table query that has populated a table called casemaster local with only the outstanding records from the large database. However, I need to be able to automatically update the casemaster local table with the outstanding records each time the Reports database is opened. Is this possible?



Any help would be gratefully received.

[NTC]

somewhat depends on what is meant by "automatically" ....but manually you would just simply delete the existing table, and then remake it by running that query again...

so that's simple to set up those two tasks to run one after the other in a macro...
DeleteObject
OpenQuery

now to trigger the macro is easy too - you can link a button to it using the wizard - or force it maybe via the opening even of your start form....

hope it helps.

[andrewosborne]

Thank you for the pointers - it is most appreciated.

I am sorry that I did not make myself clear when I said "automatically". I would like to open up the database and run the macro to delete the existing table and then run the make table query to recreate the table before the start form opens.

Is this possible?

[NTC]

you can define the macro with the autoexec name so it fires when the db opens....or put it in the StartForm's OnLoad event

probably not going to make much difference from the user experience....

[andrewosborne]

I have created the autoexec as suggested an it works perfectly.

Thanks so much for your guidance.