Recovering Damaged Databases
If you always have a backup, this shouldn’t be a problem.
- Create a copy of the damaged table
- Never work off the original table/file, damaged or not. If something happens in the process of fixing it or playing around with it, it could mean you’ll spend three times longer getting back to the original.
- Open a new table, and structure it like the damaged table
- Start copying data cells from the damaged table to the new table
- Skip any corrupted data cells (Access won’t let you copy them over anyway)
- Once all data cells are copied over, hand write in the corrupted cells into the new table
- Open a new Access database
- Import the new table (not the damaged one) into Access
- Save the new database to the same folder of the damaged database
- Find the damaged database in Windows Explorer
- Rename the damaged database and delete is .ldb file
- Rename the new database to the old name of the damaged database