Moving Records in Access 2000

  • Thread starter Thread starter Margie
  • Start date Start date
M

Margie

Is there a way to move records from one table to another
in Access 2000 without using code? I want to completely
remove the records from the original table and place them
in another table. I have appended, updated, and deleted
but can't figure out how to move.
 
"Move" is a 2-step operation: copy, and then delete.
Best approach is a pair of action queries to Append and Delete.

It's not difficult to run the queries manually if you want, but there is
always a chance that the user messes up the Where clause or fails to read
the message that the append failed and runs the deletes anyway. It is
therefore safer and easier to do it with code.

If you are interested in the code, the safest approach is to execute the
queries in a transaction so you can rollback if there is any problem.
Details of the code in article:
Archive: Move records to another table
at:
http://allenbrowne.com/ser-37.html
 
Back
Top