How to compact and repair errors in Ms Access Database

Published on 24 November 14

Alice Follow

How to compact and repair errors in Ms Access Database - Image 1

Database files can sometimes becomes corrupted or damaged. You can use Compact and Repair Database command to fix errors in Microsoft Office Access. When you compact and repair a web database which has been already published, then you should sync the database after finishing the compact and repair issue.

Why there is a need to compact and repair a database?

This article explains how this command can help you to prevent and correct the following mentioned below problems:

Database files grow with use

When you add and update data and change its design then a database becomes larger. Some of this growth generally comes either from new data or other sources.

Database files can become corrupted

Generally, if a file is shared over a network and multiple users work directly with the file at the same time which has a small risk of becoming corrupted. If users edit data in Memo fields the risk of corruption sometimes becomes greater.

There is a very less chance to loss data in database file corruption. This corruption takes place when a user changes the data and the change is interrupted because of any reason. For examples- because of network service loss, Access indicates the database files as corrupted.

Automatically compact and repair errors in a database when it closes

You can select the Compact on Close database option if you want to compact and repair errors in Ms Access database.

Click Options on the File tab.
Click Current Database in the Access Options dialog box.
Select the Compact on Close check box under Application Options.

Manually compact and repair a database

You can also run the Compact and Repair Database command manually. You can run this command when your database is open and ca also run the command on a database that is not open.

Compact and repair errors in Ms Access database that you have open

Note: You cannot perform a compact and repair operation if the other users are also currently using the database file.

Click Info on the File tab and then click Compact and Repair Database.
Compact and Repair a database that is not open

Note: You cannot perform a compact and repair operation if other users are currently using the database file. No one can use the database file while you run the compact and repair operation.

Get started Access but do not open a database.

Point on Info and then click Compact and Repair Database.

In the Database to Compact From dialog box, navigate to and double-click the database that you want to want to repair.

Create a desktop shortcut that compacts and repairs a particular database

You can create a shortcut on your desktop which you can easily use to compact and repair a specific database.

Verify the location of the MSAccess.exe file on your computer before you start. It is located in the following folder:

C:\Program Files\Microsoft Office\Office14

If you are unable to compact and repair a database from the above mentioned manual method then you can also use the MS Access Repair Tool to recover corrupted data and also it restores table structures such as primary keys, foreign keys, auto number, field size etc.

This blog is listed under Development & Implementations and Data & Information Management Community

Share this Post:

Was the blog helpful?

Microsoft Access

View Comments (13)

Post a Comment

Please notify me the replies via email.

Important:

We hope the conversations that take place on MyTechLogy.com will be constructive and thought-provoking.
To ensure the quality of the discussion, our moderators may review/edit the comments for clarity and relevance.
Comments that are promotional, mean-spirited, or off-topic may be deleted per the moderators' judgment.

Virat 23 February 17

0

apart from compact and repair you may also tryout: 1. jetcomp.exe method 2. Backup ad restore 3. Importing corrupt files to a new access for more detailed info. you may checkout this EasyTechTools blog. They have mentioned each and every step precisely and in a detailed way. Plus they have also mentioned the reasons of your files getting corrupted and precautions you can take to prevent it from corruption. https://www.mytechlogy.com/IT-reviews/4554/bring-back-valuable-files-with-ms-access-repair-tool/ Thanks
Mark 20 July 16

0

Due to any reasons, if you are unable to fix database corruption issue using compact & repair then import all tables and data from corrupt database into new blank database is good option. Additionally; you can try Stellar Access repair tool to recover data from corrupt mdb or accdb file.
Billy 29 September 15

0

I would like to suggest an advance and safer third-party access recovery tool that helps to repair corrupt or damaged access database file without any data loss. It repairs both MDB and ACCDB database file. It supports MS Access 2013/2010/2007/2003/XP/2000/97/95. You can use its free demo version.http://www.mannatsoftware.com/stellar-phoenix-access-recovery.html
John 12 August 15

0

MS Access File Repair Tool is one of the best solutions to repair corrupt ACCDB and MDB database file easily. For more information, visit: http://www.accessfilerepair.net/
Angus 20 June 15

0

The process you describe above is in right way but some times it can not repaired then the need of third party tools arise. Visit http://www.datarepairtools.com/access-recovery.html for the alternate solution to repair and compact MS Access Database successfully.
John 16 June 15

0

I would recommend a another best way to fix corrupt access database issues, download an Access database recovery tool. Because it is capable to repair and recover of access database corrupt file. It repairs both MDB or ACCDB database file. Find more information at http://www.repairaccessdatabase.com/
Larry 26 March 15

0

You can try to use third party Access file recovery program to recover your lost and corrupted data from .mdb files. For more details about this software:- http://www.recoverfilesdata.com/access-file-recovery-software.html
Sonika 28 February 15

0

The advanced MS Access Database Recovery tool of SysInfoTools performs an effective recovery of maximum possible data from corrupted MS Access database files in a very quick time.Read S. Rawat's Blog post for more information :-

Fix Corrupt Access Database using Compact and Repair

Thanks
Eugene 02 February 15

0

This is advance solution to recover corrupt .mdb files instantly and without any data loss. few days ago i was in trouble due to .mdb corrupt. My one of friend told me about Access file Recovery Tool. I was try it and this software recovery .MDB corrupted files instantly. it can recover password protected files as well. May be this will help you just try it to download click this link :- http://www.filesrepairtool.com/access-file-repair.html
Puneet 22 January 15

0

This post written very well, if you want to repair the damaged Access database then you should make use of a Access repair tool. You can know more about this tool from here: How to Repair Access Database?

Thanks
Mark 22 December 14

0

If the size of database is big then Split it into different parts (front-end, & back-end). It can prevent the corruption of database files and also minimizes the chance of data loss.

If corruption still occurs then restore the database from backup or use Access repair tool to repair the corrupt file.
Richard 05 December 14

0

If you are not accessing access database file due to some unaccepted problem then I would like to suggest you to use Kernel for Access file recovery software. The easy and effective way to repair and reocver corrupt access .mdb or .accdb files.
Try demo version: http://www.accessrecoverytool.org/
Donal 02 December 14

0

Access File Recovery Software repairs corrupted Microsoft Access databases, and undeletes or recovers Access .mdb and .accdb database files from damaged disks.

Try:- http://www.recoverydeletedfiles.com/access-file-recovery-tool.html