ACCESS Scrambling

[Guest]

We have an access 97 database that someone was working on when we had a power
outage. When she opened it back up, the data in each record had been sorted
wrong. An example is The address from record one was in record 2. How can
this be fixed. I have always trusted access over excel more because of
sorting problems. Now I am not so sure. Any help would be appreciated.

Thanks

 

[Bill Mosca, MS Access MVP]

What do you mean by sorting? I have never seen data from one record
magically migrate to another record. Can you give an example?

 

[William Hindman]

Sandy

....first, install a UPS (Uninterruptible Power Supply) between the computer
and the power outlet so that it won't happen again ...any application data
being written during a power failure is subject to corruption be it access
or excel.

....second, with your Access data mdb open, under the Tools menu, select
Database Utilities and then Compact and Repair ...in a very high percentage
of corruption events that will repair the problem.

....should that not work, come back for further help.

William Hindman

 

[John Vinson]

We have an access 97 database that someone was working on when we had a power
outage. When she opened it back up, the data in each record had been sorted
wrong. An example is The address from record one was in record 2. How can
this be fixed. I have always trusted access over excel more because of
sorting problems. Now I am not so sure. Any help would be appreciated.

Thanks

Your database is corrupt. It may or may not be possible to salvage it.

MAKE A BACKUP, IMMEDIATELY - don't overwrite any existing backups
(actually if you have an existing backup consider using it; if you
don't, make it a policy to keep regular backups, they are NOT
optional!).

Then check the suggestions at
http://www.granite.ab.ca/access/corruptmdbs.htm. Start by using
Tools... Database Utilities... Compact and Repair, and if that doesn't
work, reload your backup and try the other suggestions at Tony's site.

Good luck.

John W. Vinson[MVP]