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!
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.

Signature
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> I've been getting 2 different errors in a database.
>
[quoted text clipped - 11 lines]
>
> Thanks in advance!
Meg Brady - 31 May 2007 16:07 GMT
Yes, all our databases are on a network drive. I'll sic our network guy on it.
Thank you so much for your help!
> 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.
[quoted text clipped - 31 lines]
> >
> > Thanks in advance!