How do I restore info to a query?

T

Tracy

I created a table, with forms to add to it. I did a query with wizard and got
too much info. So.. I deleted some of the info. Now all the info I deleted is
gone from the table, also!
Help! How do I recover what I deleted?
 
B

Brendan Reynolds

You'll need to restore from a recent backup, if you have one. If you don't,
and if the data is vital, you'll need to talk to a data recovery expert. If
you're going to do that, stop using the database - in fact, preferably stop
using that PC - until you've spoken to them.

To avoid this kind of problem in the future, remember that a query is just a
view of the data that is stored in the table, it does *not* create any
separate copy of the data. What you change in the query - or in a form, or a
data access page - is changed in the table.
 
D

Douglas J Steele

Unfortunately, Access doesn't have a "trash bin": when you do deletions,
it's difficult to recover.

There are some 3rd party firms that specialize in this sort of thing:
www.pksolutions.com is one.
 
T

Tom Wickerath

Hi Tracy,
Help! How do I recover what I deleted?
Click to expand...

At this point, your only chance of recovering your records will be to
restore the latest backup copy of your database. In the future, you want to
look into using criteria to restrict the number of records returned by a
query.

If my answer has helped you, please answer yes to the question that reads
"Did this post answer the question?" at the bottom of the message thread.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I created a table, with forms to add to it. I did a query with wizard and got
too much info. So.. I deleted some of the info. Now all the info I deleted is
gone from the table, also!
Help! How do I recover what I deleted?
 
Top