The search key was not found in any record Error

[jjonesal]

I am getting this error message when attempting to delete a row in a stand-alone table (no relationships to other tables):

The search key was not found in any record.

I was updating through a form when Access 2002 terminated and the record I'm trying to delete is a record that looks like it has been corrupted. I tried compact and repair, but it won't run.

I searched the knowledge base, and found where you could get this if you tried to put to many chars in a memo field, but that doesn't seem to be the problem.

Any help would be greatly appreciated...

J. Jones J. Jones
jjones@cybrtyme.com

 

[lewatkin]

Hi,

I had the same problem. I ended up building a query that gave me all records in the table except the corrupt one and using a Make Table, made a new table. I deleted the old table - after ensuring there were no more corrupt records - then renamed the new table to the old table name. You will then have to the design view and set Primary Key then re-establish your relationships. I know it is an odd ball process, but that was all that I could find that would work.

Lee