restore previously saved database

  • Thread starter Thread starter Rita
  • Start date Start date
R

Rita

I made a mistake... I said ok to save as I was deleting records from my
query. I didn't know it would save for the entire database. Since then I
have closed out and reopened the database only to find the records gone that
I deleted. (I am new at this.)

Of course I don't have a backup version of the database. Is there any way
to go back to a previous date that it was saved? Like system restore?? Or
a hidden folder?? Any help would be appreciated.
 
Thank you. This wasn't the answer I wanted, but it was what I expected. I
won't do this again. :)
 
I made a mistake... I said ok to save as I was deleting records from my
query. I didn't know it would save for the entire database. Since then I
have closed out and reopened the database only to find the records gone that
I deleted. (I am new at this.)

Of course I don't have a backup version of the database. Is there any way
to go back to a previous date that it was saved? Like system restore?? Or
a hidden folder?? Any help would be appreciated.
Click to expand...

As Chris says... gone is GONE. Sorry.

The origin of the problem is that you (like many before you!) had a
misconception about how queries work. The records in a query have no
independent existance; a query is just a "view" of the records in your Table.
If you delete a record in a Query, that deletes *the record* - the record in
the Table. This is usually a Good Thing because you can base a Form on a
query, edit records using the form, and they will indeed be edited in the
table; but... as in this case... you can get swatted if you misinterpret the
nature of the beast!

As I've said before, the only database that doesn't need to be backed up is
one that you don't mind recreating from scratch at a moment's notice.
 
Back
Top