Moving/Deleting Records

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
 
K

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separate Form 0
Access Deleting multible records in Access 2010 1
Overriding constraint restriction message, when deleting record(s) from form 6
Invisible records in table 3
Split form problems on selection change 3
Deleting Records 1
Delete record error form / subform 1
Subform with no records 8

Top