Deleted data from Combo Box deleted table data.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pedro in Virginia - 21 Mar 2007 11:00 GMT

I deleleted duplicate data in two of my combo boxes (in query). When I
finished, I saved this on my backup. I went back in and noticed that about
90% of my table was deleted.

I stopped working on my database onthe hard drive and disc. Is there any
hope that the data can be recovered after both files were closed and saved?
I work at a large University with a good IT department. Do you think I
should contact them?

I spent 3 weeks entering this data from last year's results...and had JUST
finished.

Reply to this Message

John W. Vinson - 21 Mar 2007 17:09 GMT

>I deleleted duplicate data in two of my combo boxes (in query). When I
>finished, I saved this on my backup. I went back in and noticed that about
[quoted text clipped - 7 lines]
>I spent 3 weeks entering this data from last year's results...and had JUST
>finished.

owwwwwww.....

Good luck. There are some good data recovery services out there, but they're
not free. MAKE A BACKUP IMMEDIATELY - above all do NOT open the database, or
especially compact it. A highly recommended recovery service is
http://www.pksolutions.com, or you can check the links at:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Just for future reference, and for the benefit of others:

Queries have no independent existance. They are just pointers to data which
resides in Tables. If you delete a record from a Query, you're deleting the
record from the Table.

And... of course... backups are essential, because mistakes happen!

Good luck getting this back.

John W. Vinson [MVP]

Reply to this Message