"The search key was not found in any record."

[Haynesey]

Hi,

I have a record in my main table that is completely blank. When I try and delete it, the following message appears:

"The search key was not found in any record."

Any ideas?

Thanks

Lee

 

[KenHigg]

How many records are in the table?

Ken

 

[Mile-O]

Take off the primary key, delete the record, and apply the primary key again.

 

[NC1HOWDY]

The search key not found in any record

I'm having the same problem, I tried turning off pri key and deleting record with no success. Any other suggestions? NC1

 

[FoFa]

I have to ask, it's not the very last one always is it?

 

[NC1HOWDY]

Last One

At this point im not sure, I think there is some sort of problem with the indexes of all the fields I've entered. I do believe it is the last record, I've tried everything to delete it. This is extremely frustrating. NC1

 

[KenHigg]

Repeat:

How many records are in the table?

Ken

 

[NC1HOWDY]

Action Complete

There were 353 records in the table, I did a compact and repair on the database and deleted the corrupted record and saved the database. The problem is corrected. Thanks Ken and all others. NC1

 

[NPUser]

.. glad that you got it working again. Get into the root of the problem and don't let that happen agian. Check this link out.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;302525

KB talks about memo field indexes issue, i have that happened with simple text field (255) index as well.