General discussion

Locked

Access Table Corrupted

By jrobins ·
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?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

You need access to do these

by Tony Hopkinson In reply to Access Table Corrupted

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.

Collapse -

Re: Access Table Corrupted

by Davidpoul In reply to Access Table Corrupted

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 <a href=http://www.repair-access-file.com>access repair</a> tool.

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums