Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

deleting corrupted record

Status
Not open for further replies.
stuckagain1

stuckagain1

Technical User
May 3, 2004
86
0
0
US
Somehow one of my Access 2000 tables has a corrupted record and if i try to delete the record, i get a message that says "the search key was not found in any record." and it won't allow me to delete or edit the record......

how can i handle this?

thanks!
 
Sort by date Sort by votes
You may consider a maketable query based on your table excluding the corrupted record.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Using data macro to alert user when record is added to a table.
Replies
2
Views
54
Andrzejek
Andrzejek
bigdavidt
  • Locked
  • Question
Error 3022 when navigating from one record to another record.
Replies
2
Views
43
bigdavidt
bigdavidt
Aximboy
  • Locked
  • Question
How to wait for record count before copy 1
Replies
8
Views
71
Aximboy
Aximboy
bobjackson
  • Locked
  • Question
Copy specific field for each record in filter results in a form to another table
2
Replies
26
Views
128
bobjackson
bobjackson
blueman124
  • Locked
  • Question
All records not showing in access table that is linked to sharepoint list
Replies
0
Views
45
blueman124
blueman124

Part and Inventory Search

Sponsor

Back
Top