RESTORE DBA & FIELDS:HELP

[Kathrynlewis]

How do I restore database to its values? I accidentally changed numeric values, by doing ctrl+F Replace and when I did that I was attempting to delete all 0. consequently, any value that was 10 or 100 or 1000 has now been reduced to 1. All the values that were at 50 are now showing as 5 etc.....Is there any way to recoup the original data from before I started playing with it? THANKS FOR ANY HELP......URGENT ....MAY LOSE MY JOB...........

 

[67peshawar294]

Kat,
Have you tried the undo command in the edit menu? If you haven't done anything else since the incident it should replace the values. The best solution, in hindsight is Backup,backup,backup.
jim

 

[willir]

How do I restore database to its values?

A little late no doubt.
If the single record is loaded in a form, hit the ESC key twice.

If the form is closed, or if you are talking about multiple records, you have to restore the database from a backup copy.

...On your side, a database front end should include certain percautions to protect the integrity of the database.