The search key was not found in any record. (Error 3709)

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I edit data in a field and get this in a message box. Any ideas what to do
to correct this?
 
The message probably indicates a corruption.

According to:
http://support.microsoft.com/?id=301474
the JET 4 service packs address this issue. Use the Windows Explorer to
locate the file msjet40.dll (typically in windows\system32). Right-click and
choose Properties. On the version tab, should should see:
4.0.8xxx.0
where xxx can be anything. But if you don't see the 8, you need to download
the latest JET service pack from:
http://support.microsoft.com/kb/239114

Once that's correct, try compacting the database:
Tools | Database Utilities | Compact/repair

If the problem remains after that, get Access to rebuild the database for
you by following the steps for the first symptom in this article:
http://members.iinet.net.au/~allenbrowne/ser-47.html
 
Back
Top