Microsoft Access is Microsoft’s proprietary Database Management System (DBMS) which is being preferred by many corporates and individuals because of the ease of use and easy to grasp interface that it offers. However, Access database files i.e. (.ACCDB & .MDB) at times get corrupt due to numerous reasons that make the database inaccessible. In order to access those data, you need to repair corrupt Access database using Access Database Repair software or other ways.
In this blog, I am going to explain in detail how to repair damaged Access database files using the best powerful software, compact and repair tool, and other alternative manual methods so that you can access your data without losing any data.
So, read this blog until the end…
Points Covered in this Post
For the quick precipe of this complete blog, you can take a look over the highlights. If you are eagerly looking for the fixes to troubleshoot corrupt/damage Access Database issue then you will really enjoy the list.
- Best Software To Repair Corrupt Access Database File
- Repair Access Database With Compact And Repair Inbuilt Utility
- Other Ways to Repair Corrupt Access Database
- FAQ’s Related To Access Database Repair
Best Software To Repair Corrupt Access Database File
In severe cases of Access database corruption, manual ways fail very often. In such a situation, you must try this Access Database Repair Software. This ultimate software is quite an efficient tool to repair Access database files and effectively restores Access Database objects including tables, reports, queries, forms, records, and indexes along with modules, macros, etc.
This highly proficient tool can easily fix any level of Access Database Corruption. You can recover each and every file object and restore them in new database files.
Why To Choose Access Database Repair & Recovery Software?
- Provide Complete Access Database Repair of corrupted OR damaged MDB and ACCDB files.
- Gives the option of Preview of all recoverable items before the recovery.
- Recover all Access Database Objects including Linked Table, Forms, Modules, Macros, Queries, Relationships, Indexes, and so on.
- Support all Microsoft Access versions – 2000/2002/2007/2003/ 2010/ 2013/2016/2019
Steps To Use Access Database Repair Freeware Tool
Repair Access Database With Compact And Repair Inbuilt Utility
Why Do You need To Compact And Repair Access Database?
It is mentioned above that a periodic compact and repair Access database is necessary. But do you know why it’s important to do. Well, there are mainly two important reasons for this task. So, let’s discuss them one by one.
1. Enormously Growth In Database Size:
The first one is excessive raise in the size of the database file with the time. This growth of size is due to the addition of new data to the database. Other than this, the growth of database size is formed because of the temporary objects created by database and sometimes unused space captured by deleted objects. By compacting them with the inbuilt compact and repair utility tool you can free-up this space.
2. Corruption Of The Database Files:
Secondly, when the database files (.mdb/.accdb) may get corrupted, mainly the files that are accessed by multiple users simultaneously over the shared network connection. By performing Access database repair operation you can easily fix corrupt Access database. This ultimately allows you to be continuing with the use of databases and preserving the integrity of the database.
Things That Compact And Repair Performs
After knowing why compact & repair tool is needed
it’s important to know about the list of actions that compact and repair inbuilt utility tool performs:
- This tool helps in reorganizing the page of the table so that they easily get resided on the adjacent database pages. This ultimately helps in improving the performance because the table is no more fragmented across the database.
- It also flags out all the queries so that they will recompile the next time that query is run. Well, it’s important because database statistics can change and previously complied query which have an accurate query plan.
- Clears the unused space created by objects and records deletion. The occupied space is marked as captured until it gets saved by any new database data. However, the size of the database never gets down unless you compact the database. Overall the moral of the story is the database which frequently gets into addition, deletion or updating like procedures need to be compacted frequently.
- Regenerates the table statistics which are useful in the query optimization process. As the statistics of the table get out-of-date with the time. Usually, this happens when the transaction is rolled back or if the database is not properly closed due to the unexpected power loss. Or the system gets shut down before the program that is using Microsoft jet has changed to quit completely.
Different Circumstances In Which “Compact And Repair” Access Database Inbuilt Utility Tool Can Be Used
Here are the different scenarios in which Compact and Repair tool can be used to repair corrupt Access database. Have a look, over them one by one:
1. Automatically Compact And Repair A Database When It Closes
2. Manually Compact And Repair A Database That You Have Open
3. Manually Compact And Repair A Database That Is Not Open
4. Compact And Repair A Corrupted Database When Access Prompts You
1# Automatically Compact And Repair A Database When It Closes
Select the compact on close database options in order to automatically Compact And Repair a database when it is close. This option only works for the databases that are already open. So set this database individually for each of the databases that you want to compact and repair. In the case of multi-user databases, it’s better not to avoid using this option. Using this option can temporarily disrupt database availability.
Steps To Compact And Repair A Database When It Closes
- Firstly open the access database, go to the File> Options.
- In the Access Options dialog box, select Current Database.
- In the Application Options, choose the Compact on Close checkbox.
- After then press the OK option.
- At last close your database and reopen it again to see the changes.
2# Manually Compact And Repair A Database That You Have Open
This method is for the database that you can easily open or which is already open. So here are the steps to perform this task:
- Choose File> Info > Compact & Repair Database.
- Make a copy of the compacted and repaired database in the same location.
3# Manually Compact And Repair A Database That Is Not Open
This method seems helpful when the Access database denies getting opened. But before starting up the procedure make sure that no other users are currently using the database file.
- Start Access.
- In Access 2013, Access 2016, and Access 2019:
- Go to the template page, and double-tap the Blank Database.
- Select Database Tools> Compact and Repair Database.
- In the Database to Compact From the dialog box, search for the database and make double-tap to the database which you want to compact and repair.
- This step will create a copy of the compacted and repaired database in the same location.
4# Compact And Repair A Corrupted Database When Access Prompts You
This method seems helpful when you try to open the corrupted database files. And, at that time Access prompts you to compact and repair the database. Select the yes option, as this will offer you to perform two things:
- If Access has already completed the repair process of a corrupted file, then it will display the message stating that repair was successful. You need to check out the database content to make sure everything is fine.
- In case the Access is partially repaired, it keeps track of database objects that won’t repair in a system table named MSysCompactErrors. Access will open this MSysCompactErrors in datasheet view. If you have kept backup of your database before the occurrence of the database, then you can use the MSysCompactErrors table to make a selection for the objects that need to get imported into the repaired database.
To explore system tables, make a right-click on the navigation title bar and after then in the Navigation Options dialog box, choose Show System Objects.
Things To Remember:
- Keep it in mind that compact and repair makes new database files. So any NTFS file permission applied on the original database will not be applied over the compacted database. Therefore, it’s better to use user-level security instead of NTFS permission.
- It’s good to schedule both backups and compact/repair operations to perform on a regular basis. So, it’s an excellent idea to schedule your database administration maintenance plans.
Other Ways to Repair Corrupt Access Database Files
Other than using the inbuilt utility tool compact and repair database, you have other options also to repair Corrupt Access Database. So, let’s see what are the other solutions available for Access database repair?
1# Repair Access Database using JetComp.exe
MS Access offers a freeware utility JetComp.exe, in order to repair mdb/accdb file created with Microsoft Jet database engine 3.x.
Note: Before executing JetComp.exe, you need to rename the Master Client database to PROB.mdb.
Now you can easily run JetComp.exe from the Montel Application/support directory. Here are the following steps to repair Access database using JetComp.exe:
Step 1: Firstly you need to enter the full path (MonTel Datadirectory/CLIENTDB) and name PROB.mdb in Database to Compact From (Source): field.
You need to enter full path (MonTel Datadirectory/CLIENTDB) and full name ([ClientDB] section ClientDatabaseName + “.MDB”) that is likely to be CLIENT32.MDB.
Note: don’t make modifications in any other fields.
Step 3: At last tap to the Compact option.
- Once you get success, allow other users also to MonTel.
- But if in case you won’t get the success, don’t forget to restore CLIENT32.MDB (or whatever it’s named) from your backup copy. After this, you can delete PROB.mdb.
2# Import Corrupt Access Database into a New One
The second most opted solution to repair Access Database is importing data from corrupt Access Database to the new one. Though this step doesn’t repair up your corrupt Access Database one can easily perform Access database recovery with this. So, here are the following steps that you need to follow.
Step 1: At first, open the Microsoft Access on your PC.
Step 2: on the right-hand side pane, tap to the option of “create new database” files. Assign a name for the file and choose the location. Tap to the Create option to create the new database.
Step 3: This will make a database file and open it up in the Microsoft Access program. Click the external data at the top.
Step 4: To import the Access database tap to the Access option.
Step 5: You will see a get external data Access Database window is get opened on your screen.
On this opened window tap to the Browse option to make a selection for the file that you want to import.
On the opened dialog box of File Open, browse access database files and select it by clicking. Tap to the Open option to make confirmation for the selected items.
In the edit box, you can easily take a look over the selected files. For further continuing of the process tap to the OK option.
On Import objects dialogue box, choose the objects that you want to import from the selected Access database files. After the selection of the objects, tap to the OK option.
Now you will successfully import all selected objects.
If you want to save the above performed import steps for future work then check the Save import steps box. At last tap to the Close option.
3# Deletion Of The .ldb/.laccdb File
.ldb/.laccdb file is mainly used to find which records is been locked in a shared database and by whom. If the database is open for shared usage then the .ldb/.laccdb file automatically gets created having the same name as that of the corresponding database (.mdb/.accdb).
Delete the .ldb/.laccdb file is it is present but before that close the corresponding .mdb/.accdb file.
How about an example,
Suppose, that if you open the sample database Northwind.mdb for shared use in C:\Msoffice\Access folder, then it will automatically create a file named Northwind.ldb in the same folder. Well, this .ldb file automatically gets deleted when the last user quit the database with these two exceptions:
- When the last user don’t have the permission of folder deletion that is having .mdb file
- Or when the database is corrupted
This .ldb file has the complete list of users who all have opened the Database.
4# Re-Import The ASCII File
If your Access database table is damaged and even after trying the previous step you won’t recover the table. Then in that case just try the next steps i.e Re-importing The ASCII File.
Steps to follow:
- In your Microsoft, Access, export the table to an ASCII (delimited text) file.
If you don’t know how to perform this task then check out the topic “How To Export Data Or Database Objects In Microsoft Access”.
Read this helpful article for more reference: Learn How To Export Access Data To Excel And Fix It’s Related Error.
- If any relationship associated with this table then delete it first and then delete the table from the database.
- Compact the database. And after then re-create the table or any relationship if it previously contains.
- Use the word processor to examine the ASCII file for any bad data or records and remove it.
- Now save the ASCII text file format.
- After then you need to re-import ASCII file into the newly re-created table.
- You can also re-enter any records that you were previously forced to delete.
5# Repair Damaged Form Or Reports
If your Access database form or report is got damaged then the damage can be either in the form or report itself. Or the chances are also that one or more forms or report’s control got damaged.
To fix damaged form or reports you have an option like:
- delete the form or report and import it from the backup copy of your database.
- If the damage is encountered in the form or report then create a new form or report. Then from the original form or report copy the controls to your newly created form/report.
- But if the control of the form or report gets damaged then in that case you need to create a new form/ report. After then re-create the controls on your new form/report. Recreating the controls is the best option because it’s quiet difficult to identify which control is actually having the issue.
6# Try Importing Of Objects
If the above step won’t help you in Access Database repair or recovery, they also need not worry because there are other ways still left to try.
In this step, you need to try creating a new database and import all the objects from the old database to the new one. After then create the relationships. This procedure helps you to resolve issues with the damaged system tables in the database.
Things to remember:
With the import wizard, you can’t import data Access pages. Instead, you can open the existing data access page in the new database.
Here are the steps to accomplish this task:
- In the database windows, click pages under objects.
- Tap to the New
- In the opened New Data Access Page dialog box, tap to the Existing Web page, after then tap to the Ok
- From the Locate Web Page window, search for the location of the data access page.
7# Repair Damaged Macro Or Module
If the macro or module of the Access Database is got damaged then the chance maybe that damage can be in the macro or module itself. Other than this may be the content of the macro/module somehow got damaged. Options To fix damaged macros or module:
- Just delete the macro or module and import it again from your backup copy.
- If macro or module of database got damaged then create a new macro or module and copy the contents of the original macro or module.
- Damage may encounter with your module as text file and delete any bad data if present. After then reload the text file into your new module.
- But if the content of the macro or module gets damaged then you need to create a new macro or module. After then re-create the content of the original macro or module.
If you can’t repair Access file (MDB/ACCDB) with these aforementioned methods, then you must try reliable and effective third-party software to successfully repair corrupt Access Database.
So what are you waiting for? Just download the best Access database repair tool and get your priceless Microsoft Access database records back.
FAQ’s (Frequently Asked Questions)
There you have it, the best strategies regarding Access Database Repair for any of your Access version 2002/2007/2010/2013/2016/2019.
Now, we all are eagerly waiting for your response ….which strategy from this post are you ready to try first? Are you going with manual methods or maybe you wanted to employ the third-party Access Database Repair Tool to resolve MS Access errors and blots?
Either way, let us know by leaving a comment below.