Are you looking for a solution to repair Access database or to recover data from it? You’ve come to the right place at the right time. I’m sharing useful information to repair Access database manually. This means you have no need to use any such paid tool that may cost you up to $100. You should consider a professional tool only when manual tricks fail to repair Access database. Keep reading this article for more information.
Microsoft is a leading software developer in this world that provides a wide range of products and services related to computing. Microsoft Office is one of the most popular software programs designed by Microsoft. MS Office suite contains several desktop applications and Access is one of them. Microsoft Access is a database management system, and also known as a database management tool. The database management tools are commonly used in corporate sectors, businesses and other private organisations where a large amount of data is stored and managed in a regular manner.
What is Database Management?
A database is a computer file that stores a large amount of data and information. The process of manipulation of stored data and information according to the requirements is called database management. Generally database management involves storing, managing and organising a large amount of data and information, and you can easily edit or modify it whenever required. Hence, for all these functions of database management, Microsoft Access is one of the best applications for database users.
Access allows you to build tables, queries, forms, reports, macros and VBA modules which cover both front-end (load/entry) and back-end (reporting/maintenance). In a database file if there are thousands of records, then it may take enough time to search a single piece of information. But Access helps you obtain any information very quickly by just providing a few commands.
Access Database Types
Generally MS Access saves all your data and information under two file formats: MDB (.mdb) and ACCDB (.accdb).
- MDB (.mdb) or Microsoft Access Database: MDB is the old database file format used by older versions of Microsoft Access (MS Access 2003 and earlier).
- ACCDB (.accdb) or Access Database: ACCDB is the new database file format introduced in MS Access 2007 and its later versions. Basically, it’s similar to MDB format, but it offers some additional features like storing file attachments. You can only view or edit an ACCDB file in MS Access 2007 and its later versions.
Factors Responsible for Access Database Corruption
As no computer file is immune to corruption, so as the Access database. There are numerous unforeseen reasons which can cause corruption in an computer file. In the same way, Access database is also prone to corruption and it can easily be corrupted at any point of time. Some of the most common reasons which can play an important role in database corruption are:
#1 Virus Attack
This is one of the most common reasons of data and file corruption. A virus can easily harm your computer data stored on any drive on the system. It can easily delete some part of the file or overwrite the file. In such case, the file becomes inaccessible or corrupted.
#2 Improperly Cancellation of Access Program
Suppose you are working on a database file in MS Access. All of a sudden you close the program in an improper manner or it gets terminated unexpectedly due to system power failure, then the opened database file may become corrupted and lost forever.
#3 Unexpected System Shut Down
Unexpected system shutdown is another main reason for file corruption. A computer system should be properly terminated or shut down. If not, then it may damage or corrupt all the data saved inside the system drives. It doesn’t affect any hardware device, but can easily damage the stored content.
#4 System Crash
System crash is a situation in which your computer or a program doesn’t work properly or stops working. It often gets existed after encountering errors. Due to system crash a particular computer program may appear to be frozen or hang. System crash may result in corruption, and sometimes you may lost your data forever.
#5 Hard Disk Failure
There are two types of hard disk failure: physical and logical. And both are really very harmful for your computer data. Physical failure means the damage in the hardware parts of the drive and it could be either mechanical or electrical. Logical failure can damage the previously recorded information or make it inaccessible.
#6 Improper Data Synchronisation
Data synchronisation is a process to synchronise a single set of data between two or more devices. It’s very helpful in establishing consistency among data from a source to target data storage and vice versa. But if perform data synchronisation process improperly, then the database file may get corrupt.
Common Error Messages
These are some of the most common reasons of database corruption. There are several error messages you can receive at the time of database corruption. Some of the most common error messages are:
- Unrecognised database format ‘path/filename.mdb’.
- The database ‘filename.mdb’ needs to be repaired or isn’t a database file.
- 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 is in an unexpected state.
- Record(s) cannot be read; no read permission on ‘xxxx’.
Useful Tips to Avoid Access Database Corruption
Before I let you know few solutions to repair Access database, I would like to share some highly useful tips to avoid Access database corruption. Corruption is an inevitable occurrence, i.e. it’s certain to happen. In order to avoid corruption and prevent from data loss situation, you must follow the tips discussed below:
Tip # 1: Take Regular Backup
Taking regular backup of your database is always really very helpful. If you regularly maintain the backup of Access database, this means your database is always protected or secured. Having a valid backup file means you always have an option to restore data at the time of data loss due to accidental deletion as well as corruption.
Tip # 2: Close Access Program Properly
Avoid cancelling or terminating Microsoft Access application improperly. This may cause Access database corruption. Make sure you always close Access program properly by this way: click File tab > Exit in the option.
Tip # 3: Close all the Connections Safely
Whenever you finish your work on Access database, don’t forget to close all the active connection running in the Access database.
Tip # 4: Split Access Database
You must split Access database if two or multiple users are using or accessing it at the time. You can split your database into two parts: front end and back end. Front end stores queries, forms, reports and data access pages while back end stores the entire table along with data stored in it.
Tip # 5: Collision of Mac and Windows Users
If Windows and Mac users are sharing the same network, then the chances for Access database corruption become higher than ever. Unlike Windows, Mac system creates a heavy traffic during the process of transferring and printing graphic files. Therefore, make sure you don’t allow Windows and Mac users to work on the same network at the same time.
Tip # 6: Use “Compact and Repair” Utility in a Regular Manner
One of the best ways to avoid Access database corruption is using Compact and Repair utility. It comes as a built-in tool with MS Access application which can help you boost up the performance. Also, it’s helpful in fixing Access database corruption. You should regularly use Compact and Repair utility.
Fix Access Database Corruption Manually
To fix this corruption or to repair Access database file, Microsoft provides a built-in repair feature called Compact and Repair Database. Also, it’s very useful when a database file becomes large and causes slow performance in Access program. It safely reduces the size of the file without causing any damage. However, you should create backup of the file that you’re about to compact.
Compact and Repair to repair Access database
Note: If any other user is using the database file that you’re about to Compact and Repair, then you can’t do so. Make sure no other user is currently using the same database file. And always create a backup for the database file before performing any manual tricks.
Other than using Compact and Repair Database, you can also try to import corrupt database to a new database file. Before importing your corrupt database to a new database, you should create a new blank database file. We’ll discuss it later. Before that, let’s see below how to use JetComp.exe to repair Access database.
Repair Access Database using JetComp.exe
Microsoft provides a freeware utility, JetComp.exe, to repair Access database which is created with Microsoft Jet database engine 3.x. If Compact and Repair utility fails to repair Access database, you must try JetComp.exe.
Follow the steps to repair Access database using JetComp.exe:
Note: Before running JetComp.exe, rename the Master Client database to PROB.mdb.
Now you can run JetComp.exe from the MonTel Application/support directory.
Step 1: Enter the full path (MonTel Datadirectory/CLIENTDB) and name to PROB.mdb in Database to Compact From (Source): field.
Step 2: Enter the full path (MonTel Datadirectory/CLIENTDB) and name ([ClientDB] section ClientDatabaseName + “.MDB”) which is likely to be CLIENT32.MDB.
Note: Don’t change any of the other fields.
Step 3: Finally click Compact.
- If this succeeds, allow the other users back into MonTel.
- If this fails, you’ll need to restore CLIENT32.MDB (or whatever it’s named) from the backup.
You can now delete PROB.mdb.
Import Corrupt Database to a New One in MS Access 2007
You can also try to import data from a corrupt database to a new database. Though it doesn’t repair Access database, but you can recover your data from the corrupt file. Follow the steps shown below:
Step 1: Launch Microsoft Access on your system.
Note: The Import Objects feature will help you import all the file objects like: Tables, Queries, Forms, Reports, Macros and Modules from a corrupt database to a new database file.
You may also read this article on Ways to Prevent Access Database Corruption
Professional Solution to Repair Access Database
Sometimes both these solutions may fail to repair Access database files. In such situation, you can try MS Access Database Recovery of SysInfoTools Software to repair corrupt database files and to recover all the crucial file objects from them. It supports recovery of both MDB and ACCDB files of all popular versions of MS Access. It’s highly proficient to fix any level of corruption from corrupt database files. It can easily fix the issues of header corruption or misaligned header situation. It recovers each and every file objects including BLOB, OLE and MEMO data from corrupt database files and restores them into a new database file.