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

"BlueBullDog" <(E-Mail Removed)> wrote in message
news:14E47431-27F1-48C0-B594-(E-Mail Removed)...
>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?

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.

"Jeff Boyce" wrote:

> 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
>
> "BlueBullDog" <(E-Mail Removed)> wrote in message
> news:14E47431-27F1-48C0-B594-(E-Mail Removed)...
> >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?
>
>
>

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.


"Jeff Boyce" wrote:

> 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
>
> "BlueBullDog" <(E-Mail Removed)> wrote in message
> news:14E47431-27F1-48C0-B594-(E-Mail Removed)...
> >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?
>
>
>