Any way to get deleted module back?

  • Thread starter Thread starter BlueBullDog
  • Start date Start date
B

BlueBullDog

I selected multiple objects in Access 2007 to delete at once. However, it
deleted some objects that I did not intend for it to, and left others that
should have been deleted. The database is still open on my desktop. Is there
a way to get back a deleted module? Are deleted objects held in cache until
the database is closed?
 
If you don't have a backup copy of your file from before you attempted the
delete, there's still a possibility. Anything you do that rewrites areas on
the disk risks wiping that.

Try searching on-line for recovering deleted objects and MS Access. No
guarantees ... (that's why you make backups before doing things that alter
the file...).

Best of luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
QUICKLY - Rename your database and close out of it. Then go to the RECYCLE
bin on your trashcan and RESTORE the DATABASE. Sort it on "Name" and then
look at the dates. Try and restore the one that was at least 15 minutes
before your "deletion".

Then open up the renamed database and import that module into this renamed
one.

I know this works because I had to do it last night when the thunderstorm
blew in and caught me by surprise by knocking the power out without any
warning. It was 2:15 in the morning and I was engrossed in programming.

Good luck.
 
Quickly - RENAME your database and close out of it. Go to the RECYCLE Bin
and sort it by "Name". You should find several copies of the OLD database.
Restore one that was at least 15 minutes before your "deletion".

Then open up the new RENAMED database and import the module.
 
Back
Top