Access 2002: Deleted Record Recovery
Posted on 2006-04-07
Have an Access database (I do not manage the DB, but have been called in to provide assistance) containing 2 tables: 1 table is a lookup table and the other is a table in which employees enter customer information). Apparently, last night, someone deleted approximately 18K records from the main data entry table. The database was subsequently closed, but has not, as far as I know, been compacted and repaired since the incident.
Before anyone says "Revert to a backup", I already tried this: sadly, no backup has been done on the file or the server on which the file resides for about 2 months (I know, I was shocked too). We have a file that's a couple of months old, but to revert back to it would mean losing approximately 10,000 records - not good.
So, thought I would drop a note here and see if anyone has any suggestions on how, if possible, to get these records back. I've seen discussion of some freeware and payware apps that may help, but before investing time and money into any of these, would like to hear some recommendations from the experts here.
Point value is 500 due to time and urgency considerations.
Thanks in advance for any guidance or assistance you may be able to provide.