Moving/Deleting Records

  • Thread starter Thread starter SammyH
  • Start date Start date
S

SammyH

Hi,
I'm really new to access and am trying to create a customer database. I've
got the basics mastered using templates but I'm concerned about deleting
records. What I would like to happen is:
If I delete a record from the main database it removes it from there and
saves/copies it in another "backup" table. Is this possible?
Thanks for your time in advance!
SammyH
 
The better way is to add a Yes/No field to your database named something like
Archived. When a record is old then flag it as Archived. But the data is
available when needed. In your queries include criteria for Archived field
as 0 (zero) or No.
 
Back
Top