Error 3709 on network database

  • Thread starter Thread starter MW
  • Start date Start date

MW

Registered User.
Local time
Today, 21:50
Joined
Jan 8, 2002
Messages
14
I have an Access 2000 database running over a LAN. Today the LAN connection dropped while someone had the database open. Now, when trying to close a form in the database, we get the following message: “Search key was not found in any record Error 3709” Any suggestions what causes this?

Thanks
 
As a first guess, see if you can persuade everyone to exit from the DB. Then, when you are sure they are all out (including you!), check for the existence of an .LDB file in the same directory as the shared database. If it is there when no one is in the database, you have a dangling lock file that is now desynchronized from reality.

Mechanically, what happens is, someone opens a record. They take out a lock. Now the LAN drops. Their query fails and their program exits (maybe), but because the LAN went away, their copy of Access cannot update the lock file. Now you have a lock file that contains old data in it.

If that doesn't work, repost in this thread. Perhaps someone else will have an idea for you.
 

Users who are viewing this thread

Back
Top Bottom