• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 515
  • Last Modified:

Access 2002: Deleted Record Recovery


Experts,

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.
0
Painfree888
Asked:
Painfree888
  • 2
  • 2
  • 2
  • +1
1 Solution
 
Jim P.Commented:
Found at http://www.granite.ab.ca/access/deletedata.htm

Question:  A user at work has accidentally erased the contents of an Access MDB. The file size is still as it originally was. Is there *any* way of getting the data back?

Answer: No, not really. Although the space used to store the deleted records remains unchanged, the actual contents of that storage are not just deleted, but duplicated in part. Typically, only about one out of every twenty records is recoverable, for technical reasons. Basically, although the undeleting is easy enough, Access/Jet copy the first deleted record on a page over the remaining deleted records on hat page. Typically there are twenty or more records per page, and hence the 95%+ data loss.

That said, if the table had been deleted, rather than just its records, it would indeed be recoverable. In fact, if all tables had been deleted, they would all be recoverable. But records deleted from a table that is not deleted are indeed toast, or at least predominantly so.

Additional Info: For the above you must visit a data recovery specialist such as are in the When All Else Fails section of the Corrupt MDBs page.

There are several KB articles on this topic however they have several restrictions.

Found: http://www.atroplan.com/ as a recovery service.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
As jimpen states, a data recovery specialist is your only option.  You should be able to google for them.  Be prepared to pay at least $300-ish.

jim
0
 
jerryb30Commented:
It is also important, if readily apparent, that the disk with the missing data is the importanrt object, not the file.  Copying the remaining file will probably not yield the results you want, but it will let you retain the existing remaining data.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
jerryb30Commented:
Just a thought-It might be worthwhile to examine how you determined the records are gone.  Might you have a corrupted field (like a memo field) which is suppressing the display of records?
0
 
Painfree888Author Commented:

Jerry,

Compact and repair doesn't seem to work. The file does not seem to be corrupt. What are the telltale signs of corruption that I should be looking out for?
0
 
Painfree888Author Commented:

OK, from everything that I've read, it seems there is no reliable way to get the records back. Turns out a month old copy of the DB was found, so they'll revert to that and try to recreate records that are missing.

Jimpen, while it wasn't the answer I was hoping for, your replay *was* the correct answer, so, you get the points. Thanks to all who assisted - it is much appreciated.
0
 
Jim P.Commented:
Sorry I couldn't give you a better answer.  And now, while this loss is fresh in their minds, stress backups, backups, backups! :-)

 May all your days get brighter and brighter.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now