Transfer Database

[dmorris]

I wrote a simple macro to transer data from a table in one database to another. I cannot figure out how to then delete the data from the original table. I do not want the data in two places. I suspect I may have to write some code, however I have not done this before, I have never created a module, I've done everything using macros.

 

[Carol]

The easiest way is to make a Delete Query and have the query run on a Command Button or else on the After Update of the code for the transfer of the original information.

Make a back-up before you do this to make sure that it is working the way you want it too. I would also put a warning on the button or code to inform the user that the records are being deleted and would only make the delete command visible on the archiving of the records being done first. Make sure that both set of records are co-ordinated.

 

[cargobay 69]

Why don't you just use a linked table instead?