Microsoft Access is a most important member of the Microsoft Office suite of applications. Microsoft Access is nothing but a database management system (DBMS) from Microsoft which allow users to create and maintain the database in MS Access. VBA (Visual Basic for Applications) is supported in MS Access.
Microsoft Access saves data in its own format which is based on the Access Jet Database Engine. Through MS Access you can also import or link directly to data stored in some other applications and databases. By using the MS Access, you can easily create tables, keys, queries , forms and reports.
A database is a collection of information that is related to a particular purpose or subject, such as maintaining a music collection or tracking customer orders. There are two formats in which you can save your Access file:
- Microsoft Access Database/MDB (.mdb) – MS Access 2003 and its preceding version use this MDB format to store Access file.
- Access Database/ACCDB (.accdb) – MS Access 2007 and its later versions use this ACCDB format to store Access file. This new file format allows you to save file attachments. You cannot view ACCDB file in MS Access 2003 or its preceding versions.
If the size is larger than, or equal to MS Access database 2007, then all the objects in an MS Access database are saved in the Jet .mdb or .accdb format.
Sometimes your access database file can get corrupted or damaged due to numerous reasons such as faulty networking hardware, hard disk drive failure, opening or saving the access file in other format, virus attacks, interruption in writing operation, abrupt system shutdown, and many other. Your Access file is also corrupted if you are unable to open any of the objects in the database or unable to read records.
An inbuilt Compact and Repair Utility tool in MS Access is a useful tool by which you can repair your damaged Access database file. It also reduces the size of the database file because large sized file is also one of the reasons for corruption. You must create a backup of the database file which you want to compact.
Steps to Compact and Repair Database:
- Open MS Access application
- Select Database Tools tab, and then select Compact and Repair Database
- Database to Compact From dialog box will appear, now locate and specify the corrupted database file and click on Open.
This above manual solution is easy to operate. Other manual solution to repair your corrupted Access database file is to try importing corrupt database file to new database file. You need to create a new database file before starting the import process.
Gain more knowledge on how to Convert MS SQL Server’s MDF file to MS Access
Steps to Import Corrupt database file to new database file:
- Open MS Access application. Specify name and location of new database file and select Create button.
- Select External Data tab and click Access
- A window “Get External Data- Access Database” will be appeared, locate the corrupt file which you want to import by clicking on Browse button
- Give the location where you want to save the data and click OK
- “Import Objects” dialog box will be opened, select the objects of the file and click OK to import the selected objects to new database file.
Above manual solutions are very easy to operate and is a freeware solution to repair your damaged Access database file. But it might not work if the corruption is very severe. In such situation you can use third-party software which easily recovers data objects from corrupted database file.
Access Database Repair tool deals with severe any type of corruption. It successfully recovers data from your corrupted Access database file. It also recovers objects such as OLE, MEMO and BLOB from damaged Access file. You can visit SysInfoTools’ website and can try its demo version which is a freeware.