On Wed, 21 Mar 2007 03:00:40 -0700, Pedro in Virginia <Pedro in
(E-Mail Removed)> wrote:
>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.
>
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/acc...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]