By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,756 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Error Deleting record

P: n/a

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

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.