Search key can't be found message

[Roy Murdoch]

We are trying to delete records in a database. Most went
away just fine. However, 167 of the 700 plus won't allow
deletion. I keep getting a 'search key cannot be found in
any record' message. Short of deleting and rebuilding the
entire database, how do I get rid of these last 160
records.

Roy
(e-mail address removed)92.k12.me.us

 

[Tony Toews]

We are trying to delete records in a database. Most went
away just fine. However, 167 of the 700 plus won't allow
deletion. I keep getting a 'search key cannot be found in
any record' message. Short of deleting and rebuilding the
entire database, how do I get rid of these last 160
records.

ACC2000: "Search Key Was Not Found in Any Record" Error Message During
Compact or Save http://support.microsoft.com/?id=301474 mentions this
problem but it doesn't look like its your exact problem.

See the Damaged record(s) within tables section at the To retrieve
your data from a Corrupt Microsoft Access MDB page at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm