redirect deleted records

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

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.
 
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.
 
The append query helped. Thanks Joan!

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