corrup record

[Guest]

I have a corrupt record in one of my tables. When I try to delete it a
message is thrown up as follows
search key was not found in any record

Can I sort this? If not, what is the best way of dealing with this
corruption?

 

[Nikos Yannacopoulos]

Lynn,

Try Tools > Database Utilities > Compact and Repair Database.

HTH,
Nikos

 

[Allen Browne]

If that doesn't work, the next step is to get Access to create a table that
has all the other records in it.

Details in the 3rd symptom in article:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html

 

[Joseph Meehan]

If that doesn't work, the next step is to get Access to create a
table that has all the other records in it.

That sound do it, but there is one other possibility. Try deleting the
record before and after the bad one. Just trust me. Of course since this
means you loose data, it should not be the first thing you try.