Search key not found in any record

[Guest]

Dear all,

In a database I've built one record is giving the message "The Search key
not found in any record" if I try and edit a field I'll call field1. field1
is a memo data field which is indexed and I suspect that the error is because
a user has added 1800 words of text to this field. I can't delete the record
because I see the same error message so I'd appreciate some advice on what to
do.

Best wishes,

Alasdair

 

[Allen Browne]

Try the approach for the 3rd symptom in this article:
Recovering from corruption
at:
http://allenbrowne.com/ser-47.html

Memo data is not stored in-line with the rest of the data. The symptoms you
describe can be caused by a corrupted pointer to the data. When you cannot
delete the bad record, importing the good records into another table
*without referring the the bad record* works around the problem.

 

[Guest]

After grabbing the good records, it's also possible to salvage the bad
records by using their primary key as the criteria and leaving the memo field
out of the append query. That way you can save all the data except for the
bad memo field entry.

Once doing so I'd recommend that Alasdair copies all the tables, forms,
etc., except for the corrupt table, into another MDB file as your web page
rightly suggests.

 

[Guest]

Allen,

Thanks for the advice. I left out the bad record and moved the data into a
new table and it worked perfectly well.

Cheers,

Alasdair

 

[Guest]

Jerry,

That's a good suggestion but in this case it was only one corrupt record
which didn't have many fields filled so it is as easy to enter the data again.

Cheers,

Alasdair