Software

Ask something
Discussion Locked

Access Table Corrupted

0 helpful
2 replies

by jrobins

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have one record within an Access Table that has become corrupted. I can't do anything with it. Have tried to delete it but get a "The search key was not found in any record." When I reach a bad field, I get a "Microsoft Access has encountered a problem and needs to close." error. Same thing if I try to export to a text file--I thought if it could export the file I could manually delete the record and then reimport. Does anyone have an idea of how I can get rid of the corrupted record?

2 replies

by tony hopkinson

Take a copy first !
Not guaranteed

(1) Compact and Repair the mdb database inside Microsoft Access.

(2) Create a new, blank database and import the tables into this using File/Get External Data/Import.

There are people who offer a service in terms of getting back your data.

If you've got a lot of data, and or a lot of users, I'd look for a different tool.

by davidpoul

Compact and Repair the mdb database.

Create a new, blank database and import the tables into this using File/Get External Data/Import. If still you are facing the problem than you need to go for third party access repair tool.

This discussion is closed to new replies.