Error: The search key was not found in any record

[Guest]

Hi there,

I am opening my table directly and trying to delete a record and all it does
is send me a message: "The search key was not found in any record" . I cannot
even edit the record.

I tried "Compress and repair" and it didn't work.

My table is linked to several other ones, but only one has enforced
referencial integrity, with update and delete options NOT set. In this only
table, there is NO data for this related record.

What can I do? I have never seem this before and my help is not complete.

Thank you

Mauricio Silva

 

[Allen Browne]

Hi Mauricio

The symptoms you describe indicate a corruption, either a corrupted index,
or a corrupted pointer.

See:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html
The 2nd symptom describes how to handle a corrupted index, and the 3rd one,
how to rebuild your table aftera a corrupted pointer.