Error 3709 - Search key was not found in any record.

[KornGeek]

I'm hoping that somebody might be able to make sense of what I've found. I have a database that records a series of transactions. In single-user mode, everything works great. However, when two or more users create transactions at the same time, I'm getting error 3709 (The search key was not found in any record).

Opening the table directly after this error occurs, one of the fields of the transaction record appears to be blank. Any attempt to modify the data in this field results in the same error. This is a simple text (not memo) field with a maximum of 25 characters. Also, attempting to delete the record results in the same error.

I noticed that there is an index on this field (Duplicates OK). If I remove the index, and then put it back, the record can then be edited and/or deleted. However, as soon as two users go to write transactions again, the error reappears.

I currently have turned off the index on this and similar fields, and it is working, but this doesn't seem to be a good long-term solution. I do a lot of searching and querying on this field, so an index makes sense to me.

Even if I have to leave the index disabled, it would help if I could at least make some sense out of what is happening.

Thank you for whatever guidance you can offer.

 

[KornGeek]

Does anybody have any idea why this might happen? It seems hard to believe that I'm the only one encountering this error due to an index on a field. Hopefully somebody can offer some insight.

Thank you.