Is there any way to recover records deleted from a table?

Question

I accidently deleted all records from a table in Access.  Is there anyway to recover them other than having a backup of the access file?

Answer 1

Joe

I don't think retrieving deleted records is ever possible. Once there is a commit, it's a done deal. Objects are another thing because the MSysObjects table holds the items until the DB is closed or compacted.

Answer 2

If you're very, very lucky, and have accumulated lots of good karma... maybe. But in reality, probably not. See http://www.granite.ab.ca/access/deletedata.htm and references therein.

For the benefit of the lurkers, backing up your database (the backend if it's split, as it should be) is absolutely essential. The only databases that don't need to be backed up are ones that you're willing to either reenter manually from scratch, or discard without regrets.

Good luck!

Answer 3

I guess if the size is the same those records might be lurking somewhere. You could make a lot of money if you found out how to do a big Undo at that point. [smile]

Answer 4

Maybe, but since if you delete 1M records ... and the DB size remain approx the same ... until you do a C&R ... just sayin' ....

Answer 5

IF ... you have done a Compact and Repair since the deletion, then no.

Otherwise, if anyone can do this, it would be Wayne Phillips

http://www.everythingaccess.com/accessdatabaserepair.htm

This shows how to recover objects that have been (flagged for) deletion - IF - no C&R has been executed.

http://www.everythingaccess.com/tutorials.asp?ID=Undelete-Tables-and-Queries-in-Access

Good luck on this.