errors

[Meg Brady]

I've been getting 2 different errors in a database.

The first is when I try to save a record - sometimes I get an error telling
me that "The search key was not found in any record".

Another error I sometimes get is when my data in the record changes to
Chinese figures, and the Row ID is deleted.

It seems like individual records are getting corrupted, but I don't know
why. My workaround for both these errors are to copy all the data except the
corrupted record into a blank database, then re-enter the corrupted record.

Does anyone know why this is happening, and what I can do to prevent this?

Thanks in advance!

 

[Jerry Whittle]

At times like this, nothing beats a good backup. In fact make a complete
backup of your database now and put it away for safe keeping.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

Are these databases on a network drive? If so I suspect a network problem
like a bad switch, router, or even a network card (NIC) that can be on a
computer not even using the databases! I suggest that your network people run
a sniffer to look for bad packets and other problems. Access would be a good
network stress testing tool as if there is a weakness, Access seems to find
it.

 

[Meg Brady]

Yes, all our databases are on a network drive. I'll sic our network guy on it.

Thank you so much for your help!