Is your database frequently showing “Microsoft Access has detected corruption in this file” error(29072) each time you try to open your Access file?
Is your database unable to process any command and gives “Microsoft Access has detected corruption in this file,” error?
This error generally appears on the screen when the user tries to access data or give any command to the database.
Well if your answer is yes then our recommendation is just to scroll down to this post as this contains complete manual ways to resolve this Microsoft Access Has Detected Corruption error.
Best Software To Fix “Microsoft Access Has Detected Corruption…” Error (29072)
In this blog I will discuss both manual and software solutions to fix Microsoft Access Has Detected Corruption error. But at first, I want to talk about the software solution because the manual fixes are a bit tricky to perform; mainly by beginner Access database users.
For the novice users, an alternate solution is available through which they can resolve “Microsoft Access Has Detected Corruption…” error without needing any professional knowledge.
Just make use of the MS Access Repair and Recovery tool, This application is able to repair Access database .accdb or .mdb files. With the help of this tool, one can fix any type of database corruption, errors, inaccessibility, etc.
It contains a very effective scanning method with a simple user interface. These features make this tool more popular to fix corruption related to the MS Access database.
Now it’s high time to catch more information on Microsoft Access Has Detected Corruption error.
Steps To Use MS Access Repair and Recovery Tool
I am in the process of developing an Access 2013 application, and almost done. While I was fixing some errors with controls on one of the reports, seems like the database corrupted. Now, I keep getting “Microsoft office access has detected corruption in this file….etc”. Unfortunately, I don’t have a backup of the file, I can try to restore to an earlier storage point (using System Restore), but will lose considerable work. Any ideas?
About “Microsoft Access has detected corruption in this file…”
The corruption issue encountered in the access database is quite headache-ful for any Access database user. Whether this situation is encountered by any normal user or a developer, everyone feels sarcastic when encountering such a situation. Well, there are many factors that affect the integrity of access data and lead to corruption.
MS Access corruption error may appear because of several reasons like Microsoft Office malfunctioning, malfunctioning of OS, damaged file system, corruption in software, virus/malware infection, unexpected shutdown of the computer, etc. If the database gets damaged or corrupted due to any of these reasons then it leads to the consequence of error messages. Thus such a situation happens where Access Database suddenly starts showing the error message:
“Microsoft Access has detected corruption in this file. To try to repair the corruption, first make a backup copy of the file. Then, on the Tools menu, point to Database Utilities and click Compact and Repair Database. If you are currently trying to repair this corruption then you will need to recreate this file or restore it from a previous backup.”
Error Number: Error 29072
Name Of The Error: Microsoft Office Access has detected corruption in this file
Error Declaration: Microsoft Office Access has detected corruption in this file. To try to repair the corruption, first, make a backup copy of the file. Click the Microsoft Office Button, point to Manage, and then click Compact and Repair Database. If you are currently trying
Screenshot of the error:
Other Access Database Corruption Error Messages:
Have a look over some of the most commonly encountered Access Database corruption errors. These error messages generally occur when .accdb or .mdb file gets damaged:
- MS Access Error 3112: MS Access user is unable to read the records
- Access Error 3800: MS Access user can’t find index in the table
- MS Access Error 2239: The database is required to be repaired or it’s not a Database file
- Access Error 3011: Microsoft Jet Database engine is unable to find the object
- MS Access Error 3049: Cannot recognize Database Format
- The database is in an unexpected state.
- Record(s) cannot be read; no read permission on ‘xxxx’.
- Unrecognized database format ‘path/filename.mdb’.
- Microsoft Access has detected corruption in this file.
- Microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
- The database ‘filename.mdb’ needs to be repaired or isn’t a database file.
These Access errors are very irritating because it may appear when the user tries to fetch any data from the corrupted database or when tries to access their database.
Manual Solution To Fix “Microsoft Access Has Detected Corruption…” Error
Learn how to fix MS Access error 29072 manually. For this just go with the following mentioned solutions.
Solution 1: Using The Recover db() Function
To fix this type of error you may apply the below-given steps, below solution will make the damaged database error-free and you can access the data stored in the damaged database:
First Create a blank database = “C:\ Recover_db.mdb”. Then Close and exit.
After it creates another blank database and navigates to Modules Tab.
Then Click on New and Paste the given below code
Dim db As DAO.Database
Set db = DAO.OpenDatabase(”C:Corrupt_db.mdb”)
Dim xtable As TableDef
For Each xtable In db.TableDefs
If Mid(xtable.Name, 1, 4) <> “MSys” Then
rSQL = “SELECT * INTO [” & xtable.Name & “] IN ” & _“‘C:Recover_db.mdb’” & _
” FROM [” & xtable.Name & “]”db.Execute rSQL End If Next xtable MsgBox “Process Complete.”
“Microsoft DAO 3.6 Object Library”. After it clicks on the OK button and go to the Menu tools, choose References
On the Module Window, click on Recover_db() Function.
At last, verify the database file names after setting up correctly and then press the F5 button.
MS Access in combination with its Jet Engine tries to fix small Access Database errors automatically. Here is a list of some most common solutions for commonly encountered MS Access database errors.
Solution 2: Use the Compact and Repair Database Option
With the Access Database size increases with its growth. It has an inbuilt option to deal with the issue i.e compact and repair database. To know how to compact and repair your access database, follow these below mentioned steps:
- Open MS Access application
- Go to File Menu and click the Info button
- Choose the “Compact & Repair” option
- Search for the corrupt file or type the file name you want to repair.
Solution 3: Try Manual Export
Open up your corrupted Access database and manually export all elements of MS Access like tables, forms, queries, reports, etc. to any newly formed database. Follow the below-mentioned steps to manually export the ms access elements.
- First of all open MS Access application.
- Now go to the External Data tab and click on the More option from the Export group, and click Access Database.
- Select the final location in the File name box and click OK.
- After that Export dialog box will appear. Assign a new name for the element you are transferring and tap to the OK
Solution 4: Edit Windows Registry (recommended for advanced users only)
This particular solution is not for the novice users because the change did meanwhile this is just irreversible. Follow the below-mentioned steps to manually make Windows registry entries:
- Tap to the start button and type regedit in the search box.
- The registry editor option will appear on the screen. After then Select MS Access key.
- Now open File menu and choose the Export option.
- Make a selection for the destination folder from the Save in.
- Assign a name for the backup file in the File Name box and name of the preferred branch i++n Export range box and
Now you must have got how to resolve the “Microsoft Access Has Detected Corruption…” error. If the manual fixes fail to repair Access database then go with the software solution. This software solution is a guaranteed solution to fix Access corruption issue.