MS Access data recovery program
Recovery Toolbox for Access
Recovery Toolbox for Access repair tool for damaged MDB and ACCDB files
How to repair an Access database
Updated: 2026-01-09The manual for the recovery of a corrupted Microsoft Access database from damaged *.mdb or *.accdb files:
- Download Recovery Toolbox for Access from here: https://access.recoverytoolbox.com/download/RecoveryToolboxForAccessInstall.exe
- Select a source file to repair
- Preview the structure of the data and the data extracted from the damaged database file
- Select a file for saving the previously extracted data
- Press the Recover button
Microsoft Access database recovery tool
Recovery Toolbox for Access has been developed for the recovery of data and structures from corrupted Microsoft Access databases. The MS Access recovery tool is capable of repairing MDB and ACCDB database files.
How to recover a corrupted Access database
Recovery Toolbox for Access can extract data and structures from damaged *.mdb/*.accdb files and help repair incorrect Microsoft Access data files (*.mdb, *.accdb):
- Recover corrupted tables
- Recover data from damaged tables
- Recover primary and foreign keys and indexes
- Recover indexes
- Recover Viewers (exclude Viewers from Forms and Reports)
- Recover Queries
- Recover deleted tables
- Recover deleted records into a separate tables
- Preview of recovered data, structures and scripts
- Support recovery of Unicode data
- Recovery Access database queries except the ones used in reports and forms
- Support recovering Access databases starting from 2003 version and higher (2003, 2007, 2010, 2013, 2016, 2019, 2021 versions and Access for Microsoft 365)
- MDB Viewer Tool
- Identifies and displays damaged Microsoft Access databases
- Displays contents of corrupted Access tables
- Displays SQL scripts of queries and indexes from incorrect MDB files
The Access file repair software does not recover:
- forms;
- macros;
- modules;
- password protected files.
How to see Microsoft Access deleted records
Recovery Toolbox for Access opens any DB version in Microsoft Access to access undelete records and objects. Besides this, there is a possibility to recover the whole database, in case it was somehow damaged. To do this task, when MS Access record is deleted, do the following:
- Download the program using the link: https://access.recoverytoolbox.com/download/RecoveryToolboxForAccessInstall.exe
- Click on the downloaded file and deploy the software
- Use the shortcut of Recovery Toolbox for Access to access the application, it is on the desktop
- Choose the following mode Recover only deleted objects
- Click Recover for MS Access undo
If you need to undelete Access records and restore not only deleted objects, but the whole DB in Microsoft Access, choose another mode: Recover all objects.
The option of MS Access deleted restore works with any version of Access DB. Use it when Microsoft Access record is deleted to get back valuable data.
Free MDB File Viewer
Recovery Toolbox for Access is very convenient to use for viewing the contents of a damaged .mdb or .accdb file. The tool allows you to review the contents of a damaged Microsoft Access database for free an unlimited number of times, including:
- Viewing Access tables
- Viewing data inside Access tables
- Viewing the structure of a damaged Microsoft Access database
- Viewing Microsoft Access database objects, or rather review SQL scripts for creating objects inside the database
- Viewing SQL scripts for building internal and external indexes in the database
How to Open a Corrupted MDB File for Free
Recovery Toolbox for Access allows you to open a damaged MDB file in a Microsoft Access database and display all the data - spreadsheets, structures, objects, and indexes - from a .mdb / .accdb file.
How to Recover a Microsoft Access Database After Corruption
To restore data from a damaged MS Access database, you can use the latest backup or try to use Recovery Toolbox for Access. With a high probability, Recovery Toolbox for Access can return .mdb/.accdb files to their original state before corruption. To test this statement, it is necessary to:
- Download, install, and run the DEMO version of Recovery Toolbox for Access.
- Select a damaged .mdb/.accdb file.
- Run an analysis of the damaged database.
- Review recovered data.
- Select a new file name to save the recovered data.
- Choose what data you want to save.
- Save data - available in the full version.
How to Fix an MDB File
If you need to quickly fix the MDB file of a damaged MS Access database, then Recovery Toolbox for Access will allow you to do this in a couple of clicks. MDB files can be fixed by copying and fixing data from the damaged .mdb / .accdb file to a new .mdb file. The tool doesn’t fix or modify the existing MDB file. All data transfers to a new file.
Practical testing of damaged Microsoft Access database recovery: comparison of offline programs and online tools
Several times a year, Recovery Toolbox conducts applied testing of solutions for recovering data from Microsoft Access files. The main task is to understand how effectively each solution restores real tables, links, and records, as well as what steps will help improve the performance of Recovery Toolbox for Access and the online service of the same name.
The tests are based not on synthetic examples, but on real user databases that customers upload to the cloud recovery platform (the online service Recovery Toolbox for Access). This approach makes the tests as close to real life as possible and allows us to see real damage scenarios rather than laboratory cases.
How testing is organized:
- Frequency: approximately 1–2 rounds per year.
- Sample: each run includes at least 200–300 files, varying in:
- format: .mdb and .accdb;
- Access version (from older releases to Microsoft 365);
- size (from small files to large databases);
- types of damage and sources of problems.
- Anonymization: personal data and service information are masked; analysis is based on technical characteristics, not content.
In each case, at least 200-300 databases are selected for testing, differing in format (.accdb, .mdb), Microsoft Access version, size, and type of damage. Files can have a variety of defects: from broken slide structures and distorted images to loss of text data and damaged macros.
Real users send damaged databases that have been affected by a variety of factors, such as incorrect program shutdowns, saving failures, damaged data carriers, or virus attacks. This real-world sample of damaged Microsoft Access databases makes testing as close to real-world conditions as possible and allows us to objectively assess which solutions can truly help real users.
Preparation and selection of test files for testing Access database recovery
For testing, we used the most diverse set of damaged Access databases possible. The files were not filtered or pre-sorted in any way — absolutely everything that was downloaded several weeks before the test began was included in the test. This approach allowed us to make the test conditions as close as possible to real-life scenarios, when a user needs to recover data without prior preparation.
The test set included databases with different types of damage:
- Databases that cannot be opened at all;
- Databases with partially compromised data integrity;
- Databases with partial data loss;
- Databases with damaged forms;
- Databases requiring a password.
The test set of damaged databases included files created in various versions of Access (from old *.mdb formats to modern *.accdb formats), with different sizes and structures. We deliberately did not exclude password-protected files in order to evaluate how the utilities cope with such cases.
Software and services involved in the test
During testing, we checked the performance of both desktop programs and cloud-based online services for database recovery. These included:
- Recovery Toolbox for Access – https://access.recoverytoolbox.com/
- Online version of Recovery Toolbox – https://access.recoverytoolbox.com/online/
- MDB Repair Kit + OnlineFile.Repair – https://www.onlinefile.repair/access
- OnlineFileRepair.com – https://onlinefilerepair.com/access
- SecureRecovery® for Access
- AccessFIX
- Stellar Repair for Access
What exactly is checked
Programs and online tools, including Recovery Toolbox products, are compared. For each file, the following is recorded:
- Degree of structure recovery: tables, fields, data types, indexes, relationships, queries, forms, and reports.
- Data integrity: percentage of correctly extracted records, absence of broken rows and duplicates, validity of referential integrity.
- Working with complex fields: Memo/Long Text, OLE Object, attachments, auto-numbering.
- Behavior with different types of damage:
- breakage of system tables (MSys*),
- destruction of indexes and B-trees,
- schema violations (change of field types/lengths),
- breakage of links between tables,
- partial loss of content in large text fields,
- macro and module failures.
- Practical metrics: time to first result, process stability, interface clarity, resource requirements, cost.
This approach gave us a clear comparison showing which solutions are best at recovering Access files from different damaged databases.
Final results of applied testing of Microsoft Access database recovery tools
As part of the study, we collected and analyzed the performance of desktop programs and online services that recover Access databases. All results were converted to a single format, normalized according to the same criteria, and compiled into a single comparative matrix. This allowed us to objectively evaluate how each solution copes with real files and real types of damage.
| Service or program | % of files successfully recovered | Price for recovering 1 file | Comment |
|---|---|---|---|
| Online service Recovery Toolbox https://access.recoverytoolbox.com/online/ | ~67% | $10 per 1 GB | Universal utility for all devices and systems. |
| Recovery Toolbox for Access | ~64% | $25 | For Windows only |
| Online service Online.repair | ~65% | $10 per 1 GB | In addition to the service, there is a Windows utility: MDB Repair Kit |
| Online service OnlineFileRepair.com | ~64% | $5 per 1 GB | |
| SecureRecovery® for Access | ~19% | $59.99 | There is an online service |
| AccessFIX | ~16% | $39 | There is a batch mode for processing large numbers of Access files |
| Stellar Repair for Access | ~9% | $99 | Crashes very often |
Additional information and notes:
- The cost of a SecureRecovery® for Access license is comparable to the cost of recovering a single file through an online service. This may not be cost-effective if you only need to recover one document, but it is cost-effective for large volumes of work.
- Stellar Repair for Access often freezes during operation and sometimes displays uninformative or confusing error messages, which can complicate database recovery for inexperienced users.
Requirements:
- Windows 98/Me/2000/XP/Vista/7/8/10/11 or Windows Server 2003/2008/2012/2016 and above
- Microsoft Access 2003 or higher installed
Screenshots:
Selecting a source file for further processing
Preview of the structure of the data extracted from the damaged database file
Selecting a file for saving the previously extracted data
Viewing the final recovery report
Errors:
How can you repair an Access database with many errors? Recovery Toolbox for Access helps fix incorrect databases in a few clicks.
With MDB Repair Tool you can fix errors:
- Unrecognized Database Format 'FileName.mdb' (Error 3343)
- The database 'FileName.mdb' needs to be repaired or isn't a database file. (Error 2239)
- You or another user may have unexpectedly quit Microsoft Office Access while a Microsoft Office Access database was open. Do you want Microsoft Office Access to attempt to repair the database?
- The Microsoft Jet database engine could not find the object ' ObjectName'. Make sure the object exists and that you spell its name and the path name correctly. (Error 3011)
- Record(s) cannot be read; no read permission on 'ObjectName' (Error 3112)
- Cannot open database 'FileName.mdb'. It may not be a database that your application recognizes, or the file may be corrupt. (Error 3049)
- You do not have the necessary permissions to use the 'FileName.mdb' object. Have your system administrator or the person who created the object establish the appropriate permissions for you. (Error 3033)
- Invalid field data type (Error 3259)
- Unexpected error 35012
- The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. (Error 3022)
- The Microsoft Jet Database Engine cannot open the file.
- Visual Basic for Applications Project in This Database Is Corrupt.
- An "Invalid Page Fault..." error (not necessarily a corrupt database issue)
- You do not have the necessary permissions to open this object. Please contact your system administrator.
- [database.mdb] isn't an Index in this table. Look in the index collection of the TableDef object to determine the valid index names
- Microsoft Access has encountered a problem and needs to close
- Operation failed - too many indexes - reduce the number and try again
- Failure to open/failure to show error
- Microsoft jet database engine could not find object MSysDB. Make sure the object exists and that you spell its name correctly and the path name correctly. - 3011
- The Microsoft Jet database engine could not find the object MSysCompactError. Make sure the object exists and that you spell its name correctly and the path name correctly.
- The Microsoft Jet database engine could not find the object 'databases'. Make sure the object exists and that you spell its name and path name correctly.
- The Microsoft Jet database engine could not find the object 'filename'. Make sure the object exists and that you spell its name and the path name correctly.
- The Microsoft Jet Database Engine could not find object Msys*/databases. Make sure the object exists and that you spell its name correctly and the path name correctly
- Record(s) can't be read, no read permissions on 'database.mdb' - 3112
- Could not find field “xxx" - 1017
- Invalid Bookmark - 3159
- This database is in an unrecognized format. The database may have been created with a later version of Microsoft Access than the one you are using. Upgrade your version of Microsoft Access to the current one, then open this database. - 3343
- You cannot carry out this action at the present time. - 2486
- Record is deleted.
- The database has been placed in a state by user 'xxx' on machine 'mmm' that prevents it from being opened or locked. - 3704
- The database has been placed in an unexpected state.
- This database is in an unexpected state; Microsoft Access can't open it.
- The database has been converted from a prior version of Microsoft Access by using the DOA compact database method instead of the convert database command on the Tools menu. This has left the database in an unconverted state.
- Disk Error - Reserved error (-1601) 3000
- Table 'TempMSysAccessObjects' already exists.
- Record(s) cannot be read; no read permission on 'MSysAccessObjects'
- Record(s) cannot be read; no read permission on 'MSysACEs'. - 3112
- The Microsoft Jet database engine cannot find the input table or query 'MSysAccessObjects'. Make sure it exists and that its name is spelled correctly. - 3078.
- Could not use "name"; file already in use. (Error 3045)
- The specified file is currently being used by another user or session. Wait for the other user or session to finish working with the file, and then try the operation again. - 3045
- Operation invalid without current index. - 3019
- 'database.mdb' isn't an index in this table. Look in the Indexes collection of the TableDef object to determine the valid index names. - 3015
- The Visual Basic for Applications project in the database is corrupt.
- Error accessing file. Network connection may have been lost.
- This action will reset the current code in break mode. - 304548
- Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.
- AOIndex is not an index in this table.
- The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time
- This object needs a newer version of the Microsoft Jet database module
- Access crashes (Invalid Page Fault/GPF) when opening the mdb
- Microsoft Access has detected corruption in this file.
How it Works:
Download MS Access repair software from the website.
Start Install software:
- Press on downloaded installation file in browser
- Select a downloaded Access repairer installation file in Windows Explorer and press Enter or double-click on it.
Please confirm the warning message:
Run installation wizard:
Run Access recovery program:
- Double click on the icon that appeared on the desktop:
or
- Choose from the main menu: Start | Programs | Recovery Toolbox for Access | Recovery Toolbox for Access
Please select a damaged Microsoft Access file on the first page of the repair wizard in Recovery Toolbox Access:
Press the Next button:
Please confirm the start of the corrupted Access database recovery process:
The program will read and analyze a damaged MDB or ACCDB file for several minutes. Later you can see:
- Tables (structure (as SQL script), indexes (as SQL script) and records)
- Queries (as SQL script)
- Relations (as SQL script)
Press the Next button:
Select the path to save data from being recovered from the MDB database:
Press on the Recover button to start .mdb data recovery:
On the last page shows a detailed log of the Access database recovery process:
Video:
Online help:
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:
- 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.
The step-by-step manual for Recovery Toolbox for Access
You can recover a corrupted database in several simple steps:
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
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.
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.
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.
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.
Buying Recovery Toolbox for Access:
Online recovery service
Repair corrupted files online on any device
- An email with a registration code and instructions for activating this code will be sent to the user immediately after the payment confirmation.
- An email with a registration code will be sent from several different mail servers to prevent messages from appearing in SPAM filters. Accordingly, a possible duplication of registration letters received in the user's mailbox.
- To activate the registration code, you need to run the application in Windows under a user with Administrator rights.
- The number of Personal, Business or Site licenses activated simultaneously must not exceed the number of purchased licenses.
- We sell software via registration services PayPro Global and Noventiq. That is why not Recovery Toolbox, but the corresponding company will be specified in the payment documents.
The purchased registration key is valid for all 2.x versions of Recovery Toolbox for Access.
Payment Services:
PayPro Global (PayPro Global, Inc., 250 The East Mall street, Etobicoke, ON Canada, M9B 0A9) is the fastest growing eCommerce company that develops customized solutions to help software producers to easily and effectively sell software online. PayPro Global supports more than one hundred currencies, all major credit cards, and a wide variety of payment options. PayPro Global offers efficient customer support 24/7 and provides personal attention to customers having special requirements.
Noventiq online store for licensed software opened in 2004. Noventiq offers customers over 15,000 programs from 3,000 developers, provides fast delivery (electronic and physical), accepts 20 payment methods, and includes a cumulative discount system. Noventiq specialists provide customers with all the necessary advice for purchasing licensed software. Selling software is our profession!
Reasons to Buy Recovery Toolbox for Access Full Version
If you are regularly working with Microsoft Access, it is very likely that you have encountered damaged Access databases and were looking for how to repair .mdb file corruption. To minimize the risk of losing valuable data, you should use professional recovery software for a damaged access file. Recovery Toolbox for Access is one of the best MDB repair tools available on the Internet; it can recover ACCDB and MDB files without requiring special knowledge.
Here you can download the Access repair tool for free; it can view corrupt MS Access database and its contents. However, if you want to restore MDB corrupted file and work with an undamaged database, you would need to purchase an online license to unlock the full version of Recovery Toolbox for Access.
After buying Recovery Toolbox for Access, you can now start using the Microsoft Access recovery tool at its full capabilities. The software can perform all sorts of MS Access base recovery, recover indexes, queries, and deleted tables of Access. The software works with all versions of Microsoft Access and has no database file size limit. In addition, the license has no usage limit, so you can fix access files regardless of how many of them have been damaged or corrupted.
After Recovery Toolbox for Access full version analyzes the Access data files, you can complete ACCDB or MDB recovery and save data. This action will export the recovered Access data and tables to an undamaged database.
Benefits of the full version of Recovery Toolbox for Access
The free version of Recovery Toolbox for Access lets you preview a corrupt Microsoft Access database file (MDB or ACCDB) and see its contents, but it won't repair the damage or recover your data. To unlock the full functionality, you must purchase a paid version license. Here's what you get with the paid version:
- Complete Repair: The paid version can repair and recover your corrupt Access files, allowing you to access and work with your data again.
- Comprehensive Recovery: It goes beyond just tables. You can also recover queries and even deleted tables and deleted data from your Access database.
- Broad Compatibility: The software works with all versions of Microsoft Access except Access 97. So, you don't need to worry if you're using an older version.
- No File Size Limits: There's no restriction on the size of the Access file you're trying to repair.
- Unlimited Use: The License you purchase allows you to fix as many Access files as needed whenever you encounter corruption.
- Lifetime License: No need to prolong the License each year or month.
The paid version of Recovery Toolbox for Access provides a complete solution for recovering data from corrupt Access databases.
Full version vs. DEMO version
While the free demo of Recovery Toolbox for Access can help diagnose issues, the paid version offers significant advantages when it comes to actual data recovery:
- Data Restoration: The free version only allows you to preview the contents of a corrupted database, but it won't let you recover any of that data. Upgrading to the full version unlocks the ability to repair the damage and restore your tables, queries, and deleted records.
- Actionable Analysis: The free demo leaves you with limited options, as it only shows a preview. The paid version's full recovery functionality allows you to take concrete steps to save your data from a corrupted state.
- Comprehensive Recovery: The free version has limitations on what it can recover. Upgrading enables the recovery of queries, and even deleted tables, providing a more complete solution for your Access database.
- No Limitations on Use: The free demo might limit the number of files you can preview or the size of the files you can work with. The paid version removes these restrictions, allowing you to address any corrupt Access databases you encounter.
The free version is a preliminary tool to assess the damage. Upgrading to the full version empowers you to take action and recover your valuable data from corrupt Access databases.
Recovery Toolbox for Access for Windows vs. Online Service
Here's a breakdown of the advantages of the total paid version of Recovery Toolbox for Access for Windows compared to an online Access corrupt file recovery service for all devices:
Recovery Toolbox for Access (Full Version)
- Control and Security: You have complete control over your data. The software runs on your Windows machine, so your files never leave your system. This can be crucial for sensitive information.
- Offline Functionality: No internet connection is required. This can be advantageous if you're dealing with large files or have limited internet access.
- Speed and Efficiency: The recovery process happens locally on your machine, potentially making it faster than uploading and processing files online.
- Cost-Effectiveness: A one-time purchase of Recovery Toolbox grants you unlimited use for fixing future corruption issues. This can be more economical in the long run, especially if you frequently encounter corrupt Access files.
- Detailed Previews: You can often get a good preview of the recoverable data within the software, allowing you to assess the success of the recovery attempt before committing.
Online Access Corrupt File Recovery Service
- Device Agnostic: These services can recover files from various devices, including Windows machines, Macs, and even mobile devices.
- Potential for a Wider Range of File Types: the online service offer recovery for a broader range of file types beyond Access databases (.mdb or .accdb).
- Accessibility: You can access the service from any device with an internet connection, offering some convenience.
Here's when Recovery Toolbox for Access (Full Version) might be a better choice:
- You prioritize data security and control.
- You work with large Access files or have limited internet access.
- You frequently encounter corrupt Access files and want a cost-effective solution.
- It would be best to have detailed previews of recoverable data before committing to recovery.
Consider an online service if:
- You need to recover corrupt files from a device other than Windows.
- You require recovery for a wider variety of file types beyond Access databases.
- Convenience and accessibility are your top priorities.
Ultimately, the best choice depends on your specific needs and priorities.
FAQ-Wiki:
Question:
Can I recover deleted Microsoft Access records?
Answer:
Yes, Recovery Toolbox for Access allows you to recover deleted records and save them in separate tables.
Question:
Can I recover deleted Microsoft Access objects?
Answer:
Yes, Recovery Toolbox for Access allows you to recover deleted objects and data. You must select the appropriate option before saving the recovered data into a new database.
Question:
Can Relationships with the same names and cascading rules be automatically rebuilt after recovery?
Answer:
Yes, Recovery Toolbox for Access recreates Relationships if metadata is available; if some data is lost, you can quickly create them manually from a report. In most cases, foreign keys and uniqueness restrictions can be recovered. If some relationships are lost, use the recovery report (list of tables/fields/indexes) and rebuild the relationships manually:
- Open Database Tools → Relationships.
- Add table pairs and key fields.
- Check Enforce Referential Integrity and, if necessary, Cascade Update/Delete.
Question:
Are parametric and Crosstab queries restored, and will their SQL be preserved?
Answer:
The SQL script of the most saved queries, including Crosstab, can be reverted. However, if some dependencies are missing, SQL queries will require manual edits. SQL text is stored separately from table data. If the tables/fields referenced by the query are restored with the correct old names, the SQL script will open. If the table/field names have been changed, you must correct the FROM/SELECT field values in the SQL script.
Question:
What to do if the source database was split (frontend ACCDE + backend ACCDB): how to return links to external tables?
Answer:
You need to use Linked Table Manager and specify a new path to the backend. Open frontend → External Data → Linked Table Manager → check all → Relink → select ACCDB (or network path/UNC). Check the permissions of the share.
Question:
The utility extracts the deleted records into separate tables. How do you then merge them back into working tables with the keys intact?
Answer:
To do this, add the missing records using INSERT ... WHERE NOT EXISTS and UPDATE JOIN by key.
Let's say you have T (working database) and R (recovered deleted records).
INSERT new records:
INSERT INTO T (ID, Col1, Col2)
SELECT R.ID, R.Col1, R.Col2
FROM R LEFT JOIN T ON T.ID = R.ID
WHERE T.ID IS NULL;
UPDATE existing records (conditionally by date):
UPDATE T INNER JOIN R ON T.ID = R.ID
SET T.Col1 = R.Col1,
T.Col2 = R.Col2
WHERE T.LastModified < R.LastModified;
Question:
How to return indexes with uniqueness and their collations for Cyrillic after recovery?
Answer:
Indexes are usually returned wholly and correctly. Check the uniqueness and sorting for Cyrillic in the field/index properties. To do this, after recovery, open Table Design → Indexes and make sure Indexed = Yes (No Duplicates) for the required fields. Use compatible Windows/Office language options to sort Cyrillic correctly.
Question:
Will the Validation Rule and Input Mask for fields be restored?
Answer:
Validation rules and input masks are most often recovered correctly, but check the rules on tables and fields. Manual adjustments may be required for some of the data. Go to Table Design→ field properties→ Validation Rule/Validation Text and Input Mask. If the field is critical (e.g. phone/e-mail), test the input on the form/table.
Question:
Will the Rich Text mode be preserved in Long Text (Memo) fields, or will the formatting be lost?
Answer:
Rich Text and Rich Text formatting are restored. Long Text (Memo) fields with Rich Text store HTML markup. After recovery, open sample records; if artefacts are present, use Text Format: Rich Text and the HTML filter.
Question:
What happens to Attachment fields: are the files and their names/metadata preserved?
Answer:
The contents of attachments are restored in most cases. You can check file sets and names via form/table view. Attachment fields are containers with multiple files. Open Record → click on attachment → Manage Attachments to view/export. Use VBA or built-in export commands for bulk validation.
Question:
How do multivalued fields behave when exporting to a new MDB/ACCDB?
Answer:
Data is preserved when exporting to MDB/ACCDB, but it is more convenient to normalise this into a separate linkage table. Multivalued fields are hidden linkage tables (N:M). Create an explicit T_Items table and a T_ItemTags linkage table with FK on both sides. This will make the data migration and reporting work easier.
Question:
Are calculated fields (Calculated) restored in Access 2010 and above?
Answer:
Yes, calculated fields are restored. But you can double-check the formula and result type. Open Table Design → field type Calculated → formula. Make sure all field sources exist and are specified correctly.
Question:
Is partial upload possible: restore only selected tables/queries?
Answer:
Yes, it is possible. Select the desired objects in the Recovery Toolbox for Access recovery wizard. This is convenient for partial recovery.
Question:
Can I run a batch/silent recovery (for multiple files overnight)?
Answer:
No, there is no batch or command mode recovery of Access databases in Recovery Toolbox for Access and online service.
Question:
Is there a log listing recovered/unrecovered items and reasons?
Answer:
Yes, there is a detailed report of recovered data and unsuccessful operations on the last page of the program.
Question:
Will Field Description and substitutions in table properties be saved?
Answer:
Yes, Field Description and substitutions in table properties will be restored.
Question:
What should I do if there is a .laccdb file (lock file) next to the database being restored: should I close all sessions before restoring?
Answer:
Yes. Close all connections. After that, the lock file will disappear. After that, proceed with data recovery operations. The lock file indicates that the database is open—close Access on all PCs. If the file does not disappear, check all running processes on the server/NAS.
Question:
Are GUID/Replication IDs recovered and correctly transferred to the new file?
Answer:
Yes, GUID values are retained. In key-GUID tables, make sure the field type is Replication ID. When importing/merging, map GUIDs, not auto-numbers.
Question:
How to revert links to external sources (ODBC, Excel, SharePoint) in linked tables?
Answer:
You need to recreate the ODBC DSN or re-link via External Data. For ODBC, create a system DSN with the required driver (x64/x86), then External Data → ODBC Database → Link. For Excel/SharePoint, repeat the connection wizard.
Question:
Will the default field order and sorting settings be retained?
Answer:
Yes, the default field order and sorting settings are preserved.
Question:
How does the utility work with Unicode: do Cyrillic characters or emoji not disappear?
Answer:
Unicode data is saved correctly. Please make sure that your computer has the correct fonts and check if the regional settings of the database being restored and the computer where the data is being restored match. Check File→ Options→ Language, local Windows system settings and fonts in forms/reports. For exporting to CSV, specify UTF-8.
Question:
Can the database be restored if the source file was ACCDE/MDE (compiled frontend)?
Answer:
The data/tables are stored in the backend, and this data is recoverable. Frontend from ACCDE/MDE form/VBA is not retrievable.
Restore from the backend of ACCDB/MDB filesets. The frontend can be rebuilt by structure.
Question:
What if the database were encrypted/password-protected (Jet 4.x/AES)? Are there any workarounds?
Answer:
The Recovery Toolbox for Access program and service does not support the recovery of encrypted and password-protected databases.
Question:
Are cascading delete/update relationships recoverable, or do they have to be set manually?
Answer:
Yes, cascaded delete/update relationships are restored if the primary/foreign keys are returned. Otherwise, cascades need to be set and adjusted manually. Check the relationship properties: Cascade Update Related Fields and Cascade Delete Related Records. Enable cascade deletion only when you are sure of the business rules.
Question:
Can I get SQL scripts on output to migrate the structure to SQL Server/MySQL?
Answer:
Unfortunately, the program does not create SQL scripts to migrate structures and data to other platforms. But all SQL scripts for creating database structures can be copied from the preview page.
Question:
How long does it take to recover an N gigabyte file, and what factors determine the speed?
Answer:
The speed of recovering a corrupted database depends on the extent of damage, file size, media type, and number of objects.
Recovery is accelerated:
- when there is a local SSD disk;
- if no parallel processes are loading the processor;
- if there is enough RAM.
Question:
How does the utility behave with OLE Object (embedded images/documents)? Is binary data retrieved?
Answer:
Binary objects are recoverable, but manual conversion may be required. OLE stores the object along with the wrapper. For bulk retrieval and conversion, you must use form/table exports and VBA scripts.
Question:
How do I get the relationship diagram (layout in the Relationships window) back? Is the layout preserved?
Answer:
The logical relationship diagram will be preserved, but the visual layout is usually not restored correctly. You can arrange the tables manually. The Relationships panel stores coordinates of elements separately. This is a cosmetic operation and does not affect the integrity of data and relationships. Save your layout (Ctrl+S) after manual arrangement.
Question:
Can I customise the filter by dates/by object name mask when exporting the recovery result?
Answer:
No, Recovery Toolbox for Access does not provide such an option.
Question:
How does online recovery differ from the Windows version: size/confidentiality limitations?
Answer:
Online Access recovery is convenient and fast for typical cases. Recovery Toolbox for Access is the Windows version, offering convenient large file processing and recovery of sensitive data.
Online service is convenient for point and piece recovery and preview. The desktop version of Recovery Toolbox for Access makes it easier to handle large files/offline environments.
Question:
How is data privacy guaranteed for online downloads (GDPR, storage, auto-deletion)?
Answer:
The transmission of all data is encrypted. All files are deleted 30 days after the original file is uploaded. Third-party access to the data is excluded.
Question:
Is the original file modified or a new file created (essential for forensic evidence storage)?
Answer:
The original file is not modified, supplemented, or altered. All recoveries are done with a copy/snapshot of the data. The original file remains unchanged. This is important for forensic analysis and going back to the original data. It is advisable always to make a backup before any action.
Question:
Are Access 2021/2024/365 versions supported in an environment with Office 64-bit?
Answer:
Yes, they are supported. The data is compatible at the file level. For ODBC, match the driver to the bit rate. For mixed environments (x86/x64), use the appropriate DSNs and check add-ons/ActiveX.
Question:
Can the result be uploaded to CSV/SQL directly from the Recovery Toolbox for Access interface instead of creating a new MDB/ACCDB?
Answer:
No, saving data to CSV/SQL scripts is not provided in Recovery Toolbox for Access.
Question:
What should I do if my region settings (decimal separator, date format) are incompatible?
Answer:
Align the region in Windows and Microsoft Access. Convert dates through the CDate() function and numbers through substitutions. In queries, use the #YYYYYYY-MM-DD# format for dates and avoid comma/dot dependencies.
Question:
What is the return policy, and is there an option to check completeness in the demo before purchasing a license?
Answer:
If the saved data does not match the data presented on the preview page, the User can request a refund from technical support.
Resources:
- Microsoft Access on Wikipedia: https://en.wikipedia.org/wiki/Microsoft_Access
- Official website of Access: https://www.microsoft.com/en-us/microsoft-365/access/
- Microsoft Access Team Blog: https://www.microsoft.com/en-us/microsoft-365/blog/2012/08/08/access-2013-and-sql-server/
- Community: https://techcommunity.microsoft.com/category/microsoft365/discussions/access
Customer's reviews and ratings:
very good
super
One user entering manual watch times in a problem heat. Another user simultaneously in the same event was reviewing (no editing) “by lane” view all other times, and then clicked back to normal “by heat” view.
We use Hy-Tek Meet Manager for swimming and access db go corrupted by multiple uses trying to edit file at one time. I really was not successful restoring it using your software due to not knowing what tables to attempt and/or highly customized db type. We will probably start using SQL express in the future to avoid potential issues with shared DB files.
Muito bom! gostei muito!
Very good
The Access 2003 database have been damaged during a transfer wit Wetransfer. But was fixed here online. Thx!
very helpful
It recovered 85% of my flashdrive trashed Microsoft Access file. I would use it again.
nice
Great, I am 110% satisfied. Thank you for Recovery Toolbox
nice work this apps
Two Windows workstations were logged in to a small but critical Access database, one using Office 2007 and the other Office 365 local. There was a power outage and UPSs died before PCs could be logged out properly. After power was restored none of the tools provided by Microsoft could recover the corrupted accdb file. Thankfully RT got everything back, and UPSs all have nice fresh batteries now.
5 tables out of 93 were restored only partially. The rest of the tables the program fixed well. I wrote to technical support: they tried for a long time, but could not fix it.
It works. Recommended.
I recently used Recovery Toolbox for a data recovery situation, and I was extremely impressed with the results. The software was user-friendly and straightforward to use, making the entire process stress-free. The recovery was successful, and I was able to retrieve all of my important files without any issues. I highly recommend Recovery Toolbox to anyone who needs to recover lost or damaged data.
The file was damaged when my computer froze while the database was open. I had to force a reboot and after the computer came back on, the database was damaged.
I was running a MS Access file directly from dropbox this worked for several years, it was setup so every time the DB was updated dropbox backed the DB up. Last week the DB became corrupted and no recovery tool could repair it, I tried them all belive me. I lost 12 days of data as I was able to use a older file. I have now changed and tested the DB. It now gets backed up once a day and runs from my PC rather than dropbox. This is working a lot better and use idrive for the backup which has a free 10gb option. So the worst that will now happen is I loose one day of data.
The recovery tool was able to restart the database and to give me access to the Data.
Unfortunetaly the primary and foreign keys and indexes were not recovered (name changed) and the Database was not functionnal at all.
I had to take the Data from the recovery and to reimport them in a previous backup.
So I am a little disapointed even if restoring has avoided several hours of work
it can repair Access 2007 MDB file well
Write on the Errors page that you can fix the "Invalid argument" error. First I installed the demo version and waited for the preview (it took about 3 hours). After the data I saw, I bought a license and the program asked me to restart everything again. In general, I spent 6-7 hours, when it could be done 3 hours faster.
The software helped me repair my Access 2007 DB. Simple steps to fix. I recommend
Even the portable version of the program was not useful, as the online repairing quickly fixed the errors of the .accdb file.
The program checked the file and fixed errors in it. If I could select the tables I needed, I would probably spend less time repairing the file. Think about it
MS Access unable to read the .MDF file which was modified less than an hour ago. The breakdown occurred due to a change in the form and in part of the logic in macros. After repaired, I was left without a form and macros :D, but with a working file.
Can't use this Microsoft Access for big projects, it always breaks, problems with save the .mdb file correctly. If not for you, I probably would not have been able to pass my term paper at the university. My database broke at the last moment, when there was a week left before the project was delivered. Thanks for repairing
My .mdb file needs some errors fixes. I'm lucky that you can repair any version of Access file. I have Access 2007, I was able to fix the corrupted file
Access displays an error message when trying to open a database, and most importantly, the error is not written in Latin, but in some incomprehensible hieroglyphs. The base does not respond to the queries, even through macros. I was advised your program on the Access forum. The demo version of the program repairs the database, but I have not decided to buy yet, since it does not fix its forms.
To fix error "3197 no table found" in Access, I had to spend a lot of time for repair MS Access database by online.
After VB coding, my query broke .MDF file. While I try to open file, Access reports error "Query 'turists" is corrupt" and other tables also corrupted. I used step-by-step instruction for recover but for unknown reason, in some cells in table missing data.
MS Access 2003 crashes with a critical error into the system because the form has stopped working. In VBA, forms open, but when you save, the result is the same. I decided to restore and redo everything in MS Access 2010 so that there was a .ACCDB format, but when fixing the file, I could not restore the last form from 7. As a result, I had to pick it up and manually register it in MS Access 2010 with VBA code.
I was looking for a program to restore Access on Windows 32-bit for a long time. The program restored all forms in the .MDB file, but in the "register" and "enter" forms, the password fields were replaced with a simple text field.
Fixing Access 2007 database with "Compact and Repair Database" command doesn't work any more. As it turned out, the file was just corrupted. After restoring my .ACCDB file, everything worked, the main thing is that the forms did not recover, but the database is in good condition. Thanks.
Its really work, because I can repair the selected database from the deleted Access file which one I recover from hard disk. And $27 for repair damaged MS Access 2010 accdb file cheaper than I would give it to IT specialist. Good job!
I had some dozens of corrupted .MDB files. I used Recovery Toolbox for Access, it restored them all for couple minutes.
+ Quite easy interface in comparison with other recovery tools for MS Access.
- Tool is smart money, nothing in excess...
Wonderful tool. I didn't expect such tremendous result. Tables, queries and data was restored by Recovery Toolbox for Access.