redirect deleted records

[Guest]

Hi everyone.
I'm just about ready to implement user-level security on my database. I
have set it up so that no one but me can delete any records. However, I
would like to redirect any records I delete into a separate table, just in
case I make a mistake or need to look at those records again.
First question, obviously, is this possible? If so, how would I do it?

Thanks in advance.

 

[Joan Wild]

Instead of actually deleting the record, you could add a yes/no field called deleted. Just update the field to yes. All your queries/forms/reports could then have recordsources that exclude the records that are checked.

If you really want them in a separate table, you'd use an append query to append to the table, followed by a delete query.

 

[Guest]

The append query helped. Thanks Joan!

Instead of actually deleting the record, you could add a yes/no field called deleted. Just update the field to yes. All your queries/forms/reports could then have recordsources that exclude the records that are checked.

If you really want them in a separate table, you'd use an append query to append to the table, followed by a delete query.