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

E

Ed

I edit data in a field and get this in a message box. Any ideas what to do
to correct this?
 
A

Allen Browne

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IOS App: Contacts in search or in new mail not found 0
VBA word change keys 0
RunTime 3709 1
Split form 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
sqlite-odbc write conflict 2
search key was not found in any record - isam seek error 3
Macro warning in word 1

Top