Being an MS Access Application user you must be encountered with the situations like database corruption. When such troublesome situation occurs, it is almost impossible to recover data from database.
Well most of you think so….right? But actually it’s not so…..as there are some tricks that you can try to recover your data from corrupt/damaged Access Database 2010, 2013 And 2016.
Reasons For Access Database 2010, 2013 And 2016 Corruption:
- In meticulous situation a database may turn corrupted. If file is distributed over network and manifold users work openly on that file concurrently, then it has minute risk of corruption.
- Risk of corruption is always greater if users regularly edit Memo field data, and risk increases with time. You can alleviate this danger using Compact and Repair Database feature.
- Such corruption often results from problem of Visual Basic for Applications (VBA) module and doesn’t risk any loss of data.
- Although such corruptions pose risk of database damage, VBA lost code or impracticable forms.
- File corruption could result in data loss. Typically this loss is imperfect to last action of one user; that is, a solitary modification to records.
- When user makes any change and it is interrupted for any reason like network failure, or human error then Access shows database file is corrupted.
Access prompts you to repair a corrupted database file
After corruption when you try opening database that is tainted, you are encouraged to allow Access to repair file. And you can also manually operate Compact and Repair Database command and open corrupted file.
If the in-built feature totally repairs corrupted file, it exhibits message showing that repair successfully completed and you can check the content to be assured of it.
Manual Method to Repair Corrupt Access Database
Here are the following steps of manual method that you can try to repair a damaged Access database:
Solution #1: Run Compact And Repair Utility
To do so, follow these steps:
In MS Access 2003
- Go to Tools menu, select Database Utilities.
- From there select Compact and Repair Database.
In MS Access 2007
- Click on Office button then click on Manage.
- From there select Compact and Repair Database.
In MS Access 2010
- Click File menu then click on Info
- Select Compact and Repair.
In MS Access 2013
- Click the Database Tools tab
- Go to the Tools group
- From there select the Compare and Repair Database
Once, you select the Compact and Repair in any version of MS Access, the application will perform the repair and recovery process. Once the repairing process completes, the database file will restart with the fresh file without any corruption. But, if your problem still persists then you can opt for MS Access Repair and Recover software.
Solution #2: Delete the.ldb/.laccdb file
If there is a .ldb/.laccdb file present then delete it. For deleting this you need to close the corresponding .mdb/.accdb file.
Actually the .ldb/.laccdb file is used to determine which records are locked in a shared database and by whom. If a database is opened for shared use, the .ldb/.laccdb file is created with the exact same name as that of the corresponding database (.mdb/.accdb).
This .ldb file is automatically get deleted after the last user exist the database but have two exceptions:
When the last don’t have delete permission to the folder containing the .mdb file or when the database is corrupted. When the .ldb file contains the list of users who all have opened the database.
Solution #3: Try Creating A New Database
if above solution fails to work, you can create a new database and import the objects, one by one, from the old database to the new one. Then try recreating the relationships. As this technique resolves the problem occurred with damaged system tables in the database.
Note: you can’t import data access pages with import wizard, open the existing data access page in the new database. For this you need to follow these steps:
- In the Database window, tap to Pages under Objects.
- Click New.
- In the New Data Access Page dialog box, click Existing Web page, and then click OK.
- In the Locate Web Page window and browse to the location of the data access page.
Solution #4: Import the ASCII File
- If the damage is occurred in the table and the previous solution won’t recover the table, try the following:
- In Microsoft Access, export the table to an ASCII (delimited text) file.
- Delete any relationship if associated with this table and then delete the table from the database.
- Compact the database.
- Re-create the table and any relationship it had.
- By making use of the word processor, examine the ASCII file for bad or strange data and delete those records. Save the file in an ASCII text file format.
- Now import the ASCII file into the newly created table
- Re-enter any records that you are forced to delete.
Solution #5: TRY PROFESSIONAL SOLUTION- Access Repair & Recovery Software
Access Repair & Recovery is software that is particularly designed to repair corrupt or damaged MS Access database files. It comes with powerful algorithm that scans even severely corrupted access database files. It also has highly interactive GUI that helps user to easily operate and repair Access database without making changes in the original structure of the file. It easily restores damage or corrupt tables, queries, indexes and other data.
This tool can easily fix all minor and major database errors and problems of MS Access 2013, 2010, 2007, 2003, 2002, 2000 on almost all version of Windows operating system such as Windows 8/7/Vista/XP/2003. Free trial version is available that you can install to check the features and reliability of the software.
How To Prevent MS Access Database Corruption?
In order to avoid mdb or accdb Access Database File corruption follow the below mentioned tips:
#Tips 1 – Create Backup Frequently
You should maintain the backup of your MS Access Database. If you maintain the backup your MS Access database regularly then you can always have the option to restore data from the backup when your Access Database gets corrupted.
#Tips 2 – Close MS Access Application Properly
It is always suggested that you must make sure to properly exit your MS Access Application properly. Select File>Exit option to close the application properly.
#Tips 3 – Close All the Connections
As and when you finish your work, it is suggested that you must close all the connection in the database.
#Tips 4 – Split your Database
If your MS Access database is accessed by two or multiple users then it suggested that you must split your database into two parts – a front end that stores queries, forms, reports and data access pages and in the back end stores the entire table along with data stored in it.
#Tips 5 – Do not allow Mac and Windows users to work on the same network
If you allow Windows and Mac users to share the same network then chances for MS Access corruption become higher. It is because Mac creates heavy traffic while transferring and printing graphic files. Hence, it is recommended that you must not allow Windows and Mac user to work on the same network at same time.
#Tips 6 – Use “Compact and Repair” inbuilt utility regularly
One can make use of “Compact and Repair” utility that comes in-built with the Access application. It helps to increase the performance and avoid corruption of the Access database files.
Above mentioned are some tips that will help you to prevent MS Access database corruption. However, if your MS Access database is already corrupt or got corrupted then at such situation it is recommended that you must opt for Access Database repair and recovery software.
Steps to Recover Corrupted or Damaged MS Access Database
Step 1 – Download and install the MS Access Database Repair software. After installing, select the corrupt Access file for repairing by clicking on “Select file”.
Step 2: This software will give you the list of all searched file in a drive. Select the file you want to repair and click on “Repair” button.
Step 3: The repairing process will start as you see in the image below and you can see the log report for detailed analysis.
Step 4: Once the repairing process completes, click on “OK” button to see the preview of the database objects.
Step 5: You can now see the preview of the repaired file.
Step 6: The tool will save repaired database by default to the location where the corrupted database was saved but it will rename the file. However, you can select your own desired location to save repaired database.
Step 7: Once you select the desired location you can then see that saving is under process.
Step 8: Finally, saving completed.