How to deal with MS Access Database Corruption Issues

MS access is popular database management system which performs its task by storing items into MDB and ACCDB file format. Both MDB and ACCDB formats are used to store all the data in the form of tables, records, queries, fields, reports, triggers, views, stored procedures and database security settings.

Like other database files, MDB and ACCDB files of Access are also very sensitive to any inconsistency because it may cause inaccessibility of files. Different causes responsible for MDB file corruptions are: JET bugs, media corruptions, multi-user Access, JET software conflict, unrecognized database format, unexpected system shutdown, virus attacks and hardware/software malfunctioning. While working with such infected Access database files, users come across some error messages indicating corruption in MDB files.

Precautions to prevent the MDB file corruption:

  • Use an appropriate UPS to make sure continuous power supply.
  • Utilize proper networking devices.
  • Save database at the safe location.
  • Exit from all DAO and ADO objects like Recordset, QueryDef, etc. during programming.
  • Stay away from fatal system errors or fix them as soon as possible if have occurred.
  • Remember to maintain the database in compact form.
  • Use TCP-IP instead of IPX on Microsoft Windows NT Server.

Manual restoration of corrupt or damaged MDB files is very difficult. However, errors happening in corrupt Access databases can be acknowledged by checking the binary structures of the database MDB files. But, you should not get worried because there is an excellent tool that can resolve all kinds of issues related to MS access database. By using this Access recovery tool knowing error codes is not necessary.

To recover data from a damaged database table, follow these steps:

  1. Make a copy of the damaged database table.
  2. Re-create or paste the structure only of the damaged database table to a new table.
  3. Open the damaged database table and the copy of the table structure so that you can see both the tables.
  4. Switch to the damaged database table. On the View menu, click Datasheet View, and then select the whole record by clicking the record selectors that are the blank buttons to the left of each record. On the Edit menu, click Copy to copy the records from the damaged database table.
  5. Switch to the new table; put the pointer in a location that will put the data in the same location that the data was located in the damaged database table. On theEdit menu, click Paste.
  6. Test the table after each copy-and-paste operation.
  7. Repeat steps 4 through 6 by using single records or small groups of records until you receive an error message while testing only the corrupted records that remain. Then, re-type any data that cannot be moved to the new table.
  8. After all records have been moved to the new table, create a new blank database in Access with a different name than the damaged database.
  9. Import the new table and all undamaged objects to the new database, and then quit Access.
  10. Rename the damaged database or move the damaged database to a new location. Delete the .ldb file for the corrupted database if the .ldb file exists, and then move the new database to the location that you want.
  11. Rename the repaired database to the name of the damaged database.

Access Database Repair tool that insures complete control over Access data during any unexpected database disaster situation. It is equipped with two recovery modes: Standard mode and Template mode. Standard mode is used to fix minor issues of Access database while Template mode is applied for severely damaged Access database. After completing scanning process, it will display all the recovered database items in tree like structure with preview for easy identification. It supports MS Access- 2013, 2010, 2007, 2003, 2000, 97 and MS Access 95. It is compatible to work with Windows 8, Windows 7, Vista, NT, XP, 2000 and Windows 2003 OS.