Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2007

Tip: Looking for answers? Try searching our database.

errors

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Meg Brady - 31 May 2007 15:04 GMT
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 - 31 May 2007 15:42 GMT
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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.