URGENT Deleted Records

[spaceherpe61]

I have been working with this Access DB for monthes and went to run a query I though was set as an update query, but was a delete query! I have not compacted or repaired the DB. I have heard the records are still there until you compact the DB, but how do you get them back? PLEASE HELP!!!

 

[sfreeman]

Sorry, but I don't believe you can undelete in Access.

In the future, you may wish to add a field to your tables that flag whether the record is to be deleted. Rather than actually delete the record, just set the flag to true, and thereafter only use the records that have the flag set to false.

If you then need to undelete a record, you only have to set the flag to false, and the record is 'undeleted'.

When you are certain that records should be deleted you can create a delete query that will archive the records.



Sam_F
"90% of the problem is asking the right question.

 

[PHV]

how do you get them back
From your backup copy of the DB.