Error Deleting record

[Chris Taylor]

I keep getting the following message when trying to delete a single record
from the table.

"Search key was not found in any record"

The record I'm trying to delete has errors in it and when the cursor is
moved over the record the "invalid Argument" error message pops up.
Any ideas on how to delete this record.
Access 2000 and Win 98SE system
TIA
--
Chris Taylor

[Allen Browne]

Chris, if the record cannot be deleted, the table will need to be recreated
without that record.

See:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Chris Taylor" <ch***@bmtool.com> wrote in message
news:yZ*******************@news20.bellglobal.com.. .

I keep getting the following message when trying to delete a single record
from the table.

"Search key was not found in any record"

The record I'm trying to delete has errors in it and when the cursor is
moved over the record the "invalid Argument" error message pops up.
Any ideas on how to delete this record.
Access 2000 and Win 98SE system
TIA
--
Chris Taylor

[Chris Taylor]

Allen
Thank you very much for your prompt reply. I'm just a newbie to Access and
didn't realize the repair function existed. I used it and am now able to
correct the errors in the record that was giving me problems.

Thanks again
Chris Taylor

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40***********************@freenews.iinet.net. au...

Chris, if the record cannot be deleted, the table will need to be recreated without that record.

See:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Chris Taylor" <ch***@bmtool.com> wrote in message
news:yZ*******************@news20.bellglobal.com.. .

I keep getting the following message when trying to delete a single record from the table.

"Search key was not found in any record"

The record I'm trying to delete has errors in it and when the cursor is
moved over the record the "invalid Argument" error message pops up.
Any ideas on how to delete this record.
Access 2000 and Win 98SE system
TIA
--
Chris Taylor