The search key was not found in any record?

  • Thread starter Thread starter Thief_
  • Start date Start date
T

Thief_

This is the error I'm getting in an Access 2000 db:

The search key was not found in any record. (Error 3709)
This error occurs when an ISAM SEEK is being executed and there are no
matching values in the index.

It seems to only occur in one field in one record. The field details are:

Name: kbDesc
Data Type: Memo
Required: Yes
Allow Zero Length: No
Indexed: Yes (Duplicates OK)
Unicode Compression: Yes
IME Mode: No Control
.....

It seems the problem is that the "Indexed" field is causing the problem but
I can not change the field property, delete the record or anything as I keep
getting the above error. What do I do and why is this happening?
 
Thief_ said:
This is the error I'm getting in an Access 2000 db:

The search key was not found in any record. (Error 3709)
This error occurs when an ISAM SEEK is being executed and there are no
matching values in the index.

It seems to only occur in one field in one record. The field details are:

Name: kbDesc
Data Type: Memo
Required: Yes
Allow Zero Length: No
Indexed: Yes (Duplicates OK)
Unicode Compression: Yes
IME Mode: No Control
....

It seems the problem is that the "Indexed" field is causing the problem but
I can not change the field property, delete the record or anything as I keep
getting the above error. What do I do and why is this happening?
Click to expand...

Usually this is a sign that an index has become corrupted However
you are indexing a field which is a Memo field. That's something
I've never tried so I'm not sure what would all happen.

At what point are you getting this message? When you go to update a
field on the table, a specific field or a specific record? Or when
you do a compact and repair?

One thing I would try is to change the Indexed field to No and see if
that gets you past this problem.

To see if it is a corruption problem do a compact and repair. MAKE A
COPY OF THE ORIGINAL MDB FIRST.

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
 
Back
Top