About 600 records in a Microsoft Access File (.mdb) have been deleted. The .mdb file size hasn't changed, being around 20 MB.

AccessFIX (Demo) shows the exact number and contents of the deleted records in its own viewer. Unfortunately the full version (which would undelete/save the records) costs around 180€.

Is there any free way to undelete deleted records?

I have already tried, with no luck in properly (if ever) undeleting the records:

  • Recovery Data Access
  • Stellar Phoenix Access Recovery
  • Mdb Recovery
  • SysTools Access Recovery
  • Advanced Access Repair
  • Advanced Office Repair
  • 4
    Replace the database file from a backup media. – Ramhound May 17 '12 at 16:02
  • Does the database have a table where deleted data is moved to in the event it needs to be recovered? – CharlieRB May 17 '12 at 17:07
  • @Ramhound obviously, no backup was taken before adding those 600 records. CharlieRB: unfortunately, not. As far as I understand, the data is still in the .mdb file, but I havent found any (free) tool to extract them. – Acro May 17 '12 at 17:19
  • 180 euros? It's daylight robbery, but I'd take the hit if your data is really worth the pain of recovery. You're wasting time and money trying other things that don't work. I trust you've learnt your lesson about backups. – user3463 May 17 '12 at 21:53
  • @RandolphWest or better 61,335 Drachmas since he is from Greece :) – Lipis May 17 '12 at 23:49

If you've closed or compact/repaired the database since the records have been deleted it's not happening.

When Access closes it will dump anything that is stored temporarily. When Access Compacts/Repairs all it does it copy the table contents to new tables, deletes the old table and then renames the new ones and builds the relationships.

Restore from backup

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.