how do I fix error 3709?

[Guest]

In one of my access tables I have a record that is pure gibberish; I have no
idea how it got created, and I'm unable to delete it. The error msg I get
is: "The search key was not found in any record. (Error 3709)"
I don't use a key for my records. Any ideas how to get rid of it?

 

[Guest]

The database is corrupt. First make a backup of the database and put it
safely away. Next do a Compact and Repair. See if that fixes it. If not I
have a document named Fix Corrupt Access Database towards the bottom this
page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

 

[Guest]

Have you tried Compact and Repair to the MDB where the table is located?

 

[Tony Toews]

In one of my access tables I have a record that is pure gibberish; I have no
idea how it got created, and I'm unable to delete it. The error msg I get
is: "The search key was not found in any record. (Error 3709)"
I don't use a key for my records. Any ideas how to get rid of it?

You have a corrupted record. It is very doubtful that compact and
repair will help.

See the Damaged records within tables section in the To retrieve your
data from a Corrupt Microsoft Access MDB page at my website
http://www.granite.ab.ca/access/corruption/corruptrecords.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

I don't know if you have tried this or not but I was having the same problem
and it worked. Thank you Jerry and Ofer.