corrupt record

[Spartan]

Hi There..

I have a database with a record I cannot delete...the
record became corrupt when two people were trying to look
at the same record.

Now when I try to get rid of this record it says...

The Search Key was not found in any record-and it will not
delete the record.

HELP!!!

 

[Richard]

Have you tried running a repair on the database. I had a
similar experience once with a record that had an
unsupported null value in it. As a result it seemed as
though Access was in a state of denial, refusing to
recognize the record. As a matter of course I did regular
repairs and compacts on this particular database as it
was used extensively. After the next r&c I was able to
remove the offending entry. Give it a try, no guarantees
but it worked in my case.