Question Help - Archive

[tils1975]

I would like to add a button to a form so that when clicked all the data in that record is moved (cut and paste) to another identical table, like archive.
I want the action to act as a delete, however instead off deleting i would prefer it to be stored in another backup table. a safty net. Any ideas ?????????

 

[pbaldy]

Generally speaking, it's a mistake. Normally you'd leave the record in the original table and add a status field. To "archive" the record, you'd simply change its status. That would let you query any and all records just by changing query criteria.

If yours is the rare exception to the rule, you'd execute an append query and then a delete query, each using the key value from the form as a criteria.

 

[Beetle]

Duplicate thread (same question asked, and same advice given);

http://www.access-programmers.co.uk/forums/showthread.php?t=233580

 

[pbaldy]

And I agree with Sean's conclusions there. The safety net is backups, not an archive table. I would only archive in very very limited circumstances.