How do I store old data after it is replaced with new in Access?

[Mitch Bott]

I have an access2000 database that needs to have the capability to store old
data after it has been erased. Preferably, the data needs to be stored in a
table. How should I go about doing this?

 

[tina]

depends on how you're "erasing" the data. are you using a Delete query to
delete entire records, or manually deleting entire records? are you using an
Update query to set the value of one or more fields in a record to Null or
overwrite the existing data with new data, or manually deleting/overwriting
data from one or more fields?

 

[Mitch]

All the data will be deleted manually.

depends on how you're "erasing" the data. are you using a Delete query to
delete entire records, or manually deleting entire records? are you using an
Update query to set the value of one or more fields in a record to Null or
overwrite the existing data with new data, or manually deleting/overwriting
data from one or more fields?

 

[Mitch]

All Data will be deleted manually

depends on how you're "erasing" the data. are you using a Delete query to
delete entire records, or manually deleting entire records? are you using an
Update query to set the value of one or more fields in a record to Null or
overwrite the existing data with new data, or manually deleting/overwriting
data from one or more fields?