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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
All the data will be deleted manually.

tina said:
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?
Click to expand...
 
All Data will be deleted manually

tina said:
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?
Click to expand...
 
Back
Top