Wednesday, April 15, 2020

How to Repair MS Access Database from Command-Line

Microsoft Access is a relational database management system that is used to store, analyze, and report information. It is the easiest way to create a database file. These database files are extremely prone to corruption. The error occurs in the binary file format of the database. It stores the data in MDB or ACCDB files. There are various reasons that could lead to Database Corruption. Few of them are listed below:
  • Hardware error
  • Software error
  • Virus attack
  • Multi-user access
  • Incorrect synchronization
  • Unexpected system shutdown

Method to repair MS Access Database from Command-Line

To repair MS Access Database, Microsoft Access provides the Compact and Repair Database option that could easily compact and repair databases to minimize corruption and increase the overall performance. We can do the following using the Command-Line.

Msaccess <path to database file>\<database file name> /compact
To do so, follow the steps below:
  1. Click on the Windows button
  2. Now in the search tab, type cmd
  3. Right-click on the Command Prompt and then Run As Administrator
  4. Now type C:\> "c:\program files\microsoft office\office12\msaccess.exe" /compact "C:\path to mdb file\abc.mdb"
  5. You can change the path and file name according to your files
This will then compact and repair the database file.

Automatic method to repair MS Access Database

  1. Download and launch Aryson MS Access Repair Tool
  2. Now, click on the Browse button and choose a corrupted file for recovery
  3. Choose Recovery mode i.e. Standard and Advance mode
  4. Select MS Access version or set to Auto-Detect
  5. Show System Tables and show System Deleted Records
  6. Click on the OK button to start the Access Database scanning process
  7. Expand the files to view them one by one
  8. Select the recovered database and then click on the Save button to save those files
  9. In this way, the MS Access Database is repaired

Benefits of Automatic Method


Another method to repair MS Access Database is by using professional software like Aryson Access Database Recovery Software. It can easily access the database manager to restore and repair severely corrupted MS Access Database. It repairs both MDB and ACCDB files. Few other features of Aryson Access Database Recovery are as follows:
  1. Easy to use GUI for better understanding and to recover data from MS Access database
  2. Repair Access Database MDB as well as ACCDB files with ease
  3. Access MDB Database Recovery tool is one of the standalone application to recover MS Access database files
  4. Retains corrupt files without harming old data
  5. Supports recover OLE Object or MEMO data types from damaged Access Database files
  6. It can restore BLOB data successfully
  7. Supports to recover both data misalignments and header issues
  8. Handle different types of Access Database corruption with Dual Recovery modes - Standard & Advanced
  9. Preview feature to preview scanned access database files
  10. Run smoothly on all versions of MS Windows Operating System
  11. Repair the forms and modules of the Access Database
  12. Compatible with MS Access 2019, 2016, 2013, and all the earlier Versions
  13. Restore Tables, Queries, Reports, Forms, and Index into an accessible form of Access Database
  14. Recovers Multilingual Data from the corrupt Access Database
  15. Save recovered Access Database as Schema or with Schema Data

Conclusion

Even though there are several methods available to repair MS Access Database, but the one which is done using third-party software is the best option.

0 comments:

Post a Comment