Wednesday, January 30, 2013

Tips to Recover Data from Damaged Access Table

Microsoft Access is a part of MS office and used to store data by several organizations. It uses tables to store records. MS Access tables may get corrupt due to several reasons like faulty hardware, virus attack, fatal system errors, power outage and many more. Owning to these reasons, you may want to recover data from corrupt tables. This blog post can surely help you in recovery of data from corrupt tables.

Steps to Recover: Perform following steps for recovery of data from a corrupt MS Access tables:
  1. First of all make a copy of your damaged Access database table.
  2. Now create a new MS Access table
  3. Paste the structure only of damaged table into new table
  4. Now you have two tables; damaged table & new table with same structure
  5. Open both the table so that you can view both the tables
  6. Switch to the damaged table.
  7. On the Edit menu, click Copy to copy the records from the damaged table
  8. Now switch to the new table, put the cursor in the same location that the data was located in the damaged table. On the Edit menu, click Paste.
  9. Perform this operation for all the data and test after each copy & paste operation
  10. After moving all the records into a new table, create a new blank database in MS Access with different name.
  11. Now import all the undamaged database objects & new table into newly created blank Access database.
  12. Close the MS Access.
  13. Rename the damaged Access database and move it to the new location. If there is .ldf file of corrupt database exist then delete it first and then after move it to new location.
  14. Now rename the newly created database with the name of corrupt database.
Additional Tips
  • Always create a copy of damaged Access database to avoid irrecoverable damage during above steps.
  • Test recovered Access database before implementing it to production environment.
  • Don't delete copy of damaged database until recovery is complete.
Applied: You can apply all the above steps for MS Access 2000, 2002 & 2003.