On-Line help of Recovery Toolbox for Access
Recovery Toolbox for Access (Download) is used for recovering data from corrupted database files in the Microsoft Access *.mdb, *accdb format. The tool is capable of performing the following operations:
Recovering data from corrupted Excel files
- Recovery of the original table structure (indexes and other parameters).
- Recovery of table data.
- Recovery of queries, except for queries used in reports and forms.
- Recovery of relations, excluding those relations that are used for displaying data.
Step-by-step manual for Recovery Toolbox for Access
You can recover a corrupted database in several simple steps:
- Select a file for further processing
- Preview the structure or the data extracted from the damaged database file
- Specify a file to save the extracted data to
- View the final report
You can stop the recovery process at any moment by choosing File | Exit, pressing the Exit button or closing Recovery Toolbox for Access by clicking the small cross button in the top right corner of the window. If you decide to stop the work of the application on stages 1, 2 or 3, the recovery process will not be finished. Users can also use the Back button to go back to the previous stage, view the data and make changes, if necessary.
Recovering data from damaged database files
Step 1. Selecting a source file for further processing
When Recovery Toolbox for Access is started, users see a window prompting to select a source file for further processing
The path to the source file and its name are entered with the help of the keyboard in input field. Alternatively, you can use a standard dialog by pressing button .
Users can also open one of the previously opened documents - the list is shown in field .
When the source file is selected, users can press the Next button to proceed to the next step of the recovery process.
Step 2. Preview of the structure of the data extracted from the damaged database file.
The preview mode allows you to see the structure of the file in the form it will be saved in.
On the left-hand side, users can see the structure of the database in a tree form and can view detailed information about each database object. The tree form consists of three main branches: Relations, Queries and Tables.
When you select a table, the window assumes the form you can see in the screenshot. Such parameters as table name and corresponding columns can be found in one of the window sections (the right top pane). Table records can be viewed in the corresponding section of the window (the right bottom pane). If you want to see all table records, please use the checkbox placed upper a list of records.
Apart from that, you can open the Indexes branch to see the Primary Key parameter, as well as indexed columns shown in accordance with their names. The second section of the screen contains the index name and several related parameters. Specifically, it shows which columns comprise the index, shows whether the specified column is required, whether columns should be unique only and whether this column contains primary key. If no index has been created for this table, the Indexes branch will not contain any values and will be empty. In this case, no database records will be shown when the index is selected.
When a query is selected, the right bottom pane of the window will be hidden and the right top pane will contain the name of the selected query and related SQL code.
When one of the relations is chosen, the right top pane will contain the name of this relation, the names of reference tables and table columns.
Please press Next to continue the database recovery configuration process.
Step 3. Selecting a file for saving the previously extracted data
Once you have finished previewing the database structure, the application will prompt you to select the name and path of the file to be used for saving the recovered data.
You can leave the settings unchanged - in this case, the application will save the output file in the same folder the original database file was in. The name of the file will consist of the name of the original file and the _repaired postfix.
Please specify the path and name of the file in the input field to save the recovered data. Besides, you can use the standard dialog for saving the file - click the icon . Please press the Recover button to start the recovery process.
If the selected file name already exists at the specified location, you will see a corresponding warning message. You will then be able to go one step back and specify another file name and/or location.
Step 4. Viewing the final recovery report
The actual recovery process takes place on this stage.
When the recovery process is started, Recovery Toolbox for Access shows messages in the journal window. Besides, these messages are saved to the Err.log file located in the Recovery Toolbox for Access folder. If a file already exists, new information will be appended to it. When a new record is added, it also contains a timestamp.
There are three message types:
- The bold font signifies that a group of data has been recovered. Users see such messages when the tool starts recovering a sequence of data of the same type, for instance, tables or queries.
- Element recovery messages are shown in normal font. These notifications tell the user that a group element has been recovered - for instance, a table structure or a query. To simplify the journal structure, such notifications are not shown during table recovery.
- The red font means an error. If the program cannot recover certain data or any other errors occur, a corresponding notification is shown in the journal. There notifications are also marked with an $Error$ string in the Err.log file.
Recovery Toolbox for Access does not recover data from encrypted files. Unencrypted password-protected files can be recovered, but passwords are lost. Besides, the software does not recover reports, pages, modules, macros, links and fields referring to other databases, Access-specific features for displaying elements in the editor field and restrictions used for value selection.
If you have looked through the journal, you can finish the process by pressing the Exit button or by selecting File | Exit. You can also go back using the Back button and specify another file for processing. Please note that the file and the folder it is stored in will not change automatically, so you will need to change these parameters manually or use the standard Browse dialog.