file recovery

S

sierrad

Can anyone tell me how to recover the original version of a database that I accidentally changed?

I had a database with 398 records, I copied it and saved it under another name. I deleted half of the records form the 2nd file, and the orginla file was also reduced by half. How can I recover the original file will all its records?
and
how can I avoid this from happening again. I was trying to create a subset of the data for a certain date range.

HELP
 
T

Tom Wickerath

It sounds like you may have inadvertently created a shortcut to your original database, instead
of a copy of the DB. Then you renamed the shortcut, double-clicked on it to open what you
thought was a copy, and deleted records.

Any chance that your operating system is set to the default configuration to "Hide file
extensions for known file types"? Not a good option to have! Better to know for sure exactly
what type of files you are working with.

Hopefully you have a somewhat recent backup of your database. That's the only way that you'll be
able to restore these records.

Tom
______________________________________________

Can anyone tell me how to recover the original version of a database that I accidentally changed?

I had a database with 398 records, I copied it and saved it under another name. I deleted half of
the records form the 2nd file, and the orginla file was also reduced by half. How can I recover
the original file will all its records?
and how can I avoid this from happening again. I was trying to create a subset of the data for a
certain date range.

HELP
 
R

Rosco

In addition to Tom's reply, To prevent this from happening again, instead of deleting records from your table, try creating a query with the criteria set to the subset of records you need. This will preserve your original data. If your subset needs to be in a table, your query can be a "Make Table" query, in which you would be creating a second table with just your data subset.

Alternatively, if you must edit your original table, make a copy of it before you edit the original. You can delete the copy after you confirm your edits, however querying is a more accepted and safer option.

Hope this helps
Rosco
 
L

Lizard03

lol I just did the same thing. About an hour ago I deleted information off
of what I thought was just a query. I go to my table and find that I've
deleted mostly everything. I did not have a second copy any where else. Is
there any way to know if perhaps I can still recover what I had deleted?
Would there be an original underneath a huge stack of file names? Please
help!
 
T

Tom Wickerath

I just noticed your post from 9/21.

Since queries are based on tables, deleting information from a query does affect the data in the
underlying table (as you have sadly discovered). I'm no expert in data recovery, but I'm afraid
your chances of recovering the data are slim to none. If you have not compacted your database
yet, then a professional recovery service *may* be able to help--I'm just not sure.

Tom
__________________________________________


lol I just did the same thing. About an hour ago I deleted information off
of what I thought was just a query. I go to my table and find that I've
deleted mostly everything. I did not have a second copy any where else. Is
there any way to know if perhaps I can still recover what I had deleted?
Would there be an original underneath a huge stack of file names? Please
help!

__________________________________________
 
Top