Database recovering with the Access Recovery Toolbox Application Step-by-Step
The Access Recovery Toolbox (download) allows recovering of corrupted Microsoft Access Database (*.mdb) files. The current version of the application provides you with the following actions:
- Recovering of the table structure (columns and indexes).
- Recovering of the table data.
- Recovering of queries (except for ones from forms and reports).
- Recovering of relations (except for ones created for viewing only).
How to repair Access database 2003?
- Select the file with the corrupted database.
- Browse the data structure to be recovered.
- Select the file to save the target database.
- View the recovering process journal.
Microsoft Access DataBase Repair tool
You can exit from the Access Recovery Toolbox at any step by selecting the File | Exit menu item, pressing the Exit button or by closing the Microsoft Access database repair tool window. If the application was closed on the Steps 1-3, the recovery process would not be completed. After the database recovering is finished on the Step 4, the Exit button will look like Exit. Also you can press the Back button to return to the previous step for viewing or changing the parameters set before.
Best MS Access repair tool
The program was successfully tested under Windows 98, Windows Me, Windows NT 4.0, Windows 2000, Windows XP, Windows 2003 Server, Windows Vista, Windows 7/8. Access Recovery Toolbox is best MS Access repair tool.
Database recovering process
Let's take a look at recovering of the db11.mdb file from the D:\AccessRecovery directory.
Once the application is started the dialog will appear asking you to select the database to be recovered.
Press the button Open and select required file. You can enter path and filename in the drop-down list using your keyboard. Also you can select one of the previously opened files from the list.
Microsoft Access file repair
After the file is selected, press the Next button to proceed to the next step of the database recovering with the Microsoft Access file repair software.
When the database file is opened, the application displays its structure.
Left part of the window contains the database structure tree where you can browse properties of each database object. This tree includes three root items: Tables, Queries and Relations.
You can see system tables (MSysObjects, MSysACEs, MSysQueries and other started with MSys), user tables (Phones, Addresses), query PhonesQuery and relations (Reference, PhonesPhones, PhonesPhones Query, PhonesPhones Query1).
Repair Access 2007 DataBase
How to repair Access 2007 database? If one of the Tables is selected, the window will look like one on the . The left window part displays name of the table and its columns while the right top part displays the table records. You can mark the checkbox to display all of the table records.
All tables have the item Indexes which contains the Primary key and Indexed columns displayed by their names. The column parameters show the Index name and included columns. Also the parameters indicate whether the column is Required, Primary or Unique. If there are no indexes created in the table, the item Indexes will be empty. When an index is selected the table records are not displayed.
Select the Phones table. It includes the following columns: LastName, HomePhone, WorkPhone, EmailAddress, MobilePhone, BirthDate, NickName, AddressID. The columns AddressID, EmailAddress, LastName and BirthDate are indexed. Names of the indexes correspond to the columns names. All indexes are not Unique and records are not required. The Primary Key includes the only one column AddressID.
How to repair Access 2003 database?
How to repair Access 2003 database? If one of the Queries is selected, the left pane is absent while the right pane displays name of the selected Query and its SQL-code.
If one of the Relations is selected, the left pane displays name of the Relation, references and related columns.
Press the Next button to continue database recovering.
After reviewing the database structure, the application will ask you to specify path and filename to save recovered database.
Default path will be identical to the source database path as well as default filename will be the same as source filename with the _repaired suffix.
To save the recovered database you should enter path and filename to the drop-down list. Also you can use standard Save dialog called by pressing the Save button.
To start database recovering press the Recover button.
If the specified file already exists the warning message will appear. You can return to the previous dialog and specify different filename or directory.
Now the recovering process is in progress.
The application will display different messages during the recovery process. These messages will be stored in the Err.log file at the Access Recovery Toolbox work directory as well. If the log-file exists at the start of database recovering, all messages will be appended to the end of file. Besides the information each file record will contain date and time.
There are 3 types of messages:
- Data group recovering messages (marked with bold font). These messages are displayed at the start of recovering of single-type items group, for example queries or table records.
- Single element recovering messages (not marked). These messages show the recovering of a single item, for example a single query or a single table structure. To simplify journal reading the recovering of table records is not displayed.
- Error messages (marked with red). If data recovering is not possible or in case of other errors, the corresponding message will be displayed. In the log-file these messages will be marked with the $Error$ string.
Current version of the application does not support recovering of the encrypted files. At the same time the password protected but not encrypted files can be recovered without password keeping. Also recovering of the following items is not supported: macroses, reports, pages, modules, references to other databases and reference columns, form entry restrictions and Microsoft Access specific options used for displaying elements in the editor window.
After viewing of the journal you can complete the work by pressing the Exit button or by selecting File | Exit menu item. Also you can press the Back button to return to the Step 1 and select other file for recovering. Note that in this case filename and path of recovered database will no be changed automatically during the Step 3. You will need to enter these values manually or use the standard Save dialog.