This blog help you in exploring each and every pinch of information regarding MS Access inbuilt feature Compact And Repair. Here are the main topics that it covers:
- What’s The Need Of Compact And Repair A Database?
- Automatically Compact And Repair A Database When It Closes
- Access Prompts You To Repair A Corrupted Database File
- How To Manually Compact And Repair An Access Database?
- How To Automatically Repair Corrupt Access Database?
So, let’s start grabbing each and every information about this helpful tool.
Database files grow rapidly when used frequently, at time obstructing performance. They also irregularly turn damaged or corrupted. You can utilize Compact and Repair Database command in MS Office Access to avert or resolve such issues.
Note: If you are trying to compact and repair a database that’s published, you must synch database after finishing compact and repair.
What Is The Purpose Of Compacting And Repairing MS Access Database?
This indication clarifies how usage of Compact and Repair Database command can aid stop and correct following issues that at times affect database: files rising bigger with use and files turns damaged.
Database Files Grow With Use
When you add and update data and its design, a database file grows in size. Some of growth appears from fresh data, while some from additional sources:
- Access formulates temporary, concealed subjects to achieve a variety of tasks. Occasionally, these objects stay within database even if Access does not require them.
- When you erase database, the disk space occupied by object isn’t automatically cultivated — and database file uses that space even after deletion.
When database fills with temporary and deleted objects, its feature degrades. Objects takes time to open, queries runs slowly, and typical tasks take extra time.
Note: Compacting doesn’t squeeze data — it turns your database file smaller by removing vacant space.
Database Files Can Become Corrupted
In specific cases, database file could be corrupted. If database file distributed over network and manifold users work openly with file at the same time, then chances of corruption is very high. Corruption risk somewhat increases if users edit data within Memo fields, and risk expands over time. You can alleviate this risk by utilizing Compact and Repair Database authority.
Habitually, such type of corruption appears from problem having Visual Basic Applications (VBA) module and doesn’t pretense data loss risk. Nevertheless, such corruption does create danger for design of database, like misplaced VBA code or impracticable forms.
Not often, database corruption result in loss of data. Habitually, such loss is limited to last action of single user; that’s, a single alteration to data. When user begins changing data and gets disturbed in between—because of network loss — Access counts that file to be corrupted. The file could be fixed, but some data might go missing after completing repair process.
Tip: Split access mdb file to avoid bloat and it also helps in preventing database files corruption and boundary data loss by maintaining data in detached file that users don’t access straight forwardly.
How To Repair Corrupt Access Database File?
When you open database file that’s corrupted, you’re provoked to allow Access repair file automatically. You can even use Compact and Repair Database manually to resolve database file corruption.
If Access entirely fixes corrupted file, it shows message after completion and that you must check database contents to ensure that everything is the way you want.
If Access is just partially doing well, it tracks objects of database that couldn’t mend that can help you to conclude what you require to recuperate from backup.
Note: Database option can be set that involves Compact and Repair Database command to operate automatically every time you shut specific database. If you’re only user of database, you must use this option. In numerous user databases, you may not wish to utilize this option, since it can temporarily dislocate database accessibility.
Things To Do Before The Compact And Repair Process
- Create proper backup of MS Access database file
- On File tab, press Save
- Under Types of File, hit Save Database As.
- Got o Advanced option, and press Back Up Database
Note: If you’ve several users, inform others so that they shun using database while you doing compact and repair procedure.
- Get permissions to operate compact and repair operation: If you’re using previous version database file and are fraction of work group, you may be not capable to practice compact and repair by yourself. If you don’t have adequate authorization and you require compacting and repairing database, speak to your work-group administrator for guidance.
How to Automatically Compact And Repair A Database When It Closes?
You can opt for Compact on Close database choice if you wish to automatically compact and repair database when it shuts.
Note: Using this option influence only database that’s open presently. You must situate this option unconnectedly for every database that you wish to compact and repair.
- On File tab, go to Options
- In Access Options dialog box, press Current Database
- In Application Options, opt for Compact on Close verify box
How To Manually Compact And Repair An Access Database?
Rather than using Compact on Close option, you can run Compact and Repair Database command. You can use the command when database is open, and you can run command even when database is closed. You can too generate desktop shortcut that operates Compact and Repair Database command on meticulous database file.
In Access 2007
- Click the Office button at the top-left corner;
- Click the Manage button at the left;
- Then you will view Compare and Repair Database commands at the right.
- Click the Database Tools tab;
- Go to the Tools group;
- Then you will view the Compare and Repair Database button.
Manually Compact And Repair Database on Access 2016
Note: Before you start with process, it is suggested that you must keep the backup of your database files that you are going to compact and repair.
The following steps is applicable to compact and repair Access Database 2016/2013/2010.
Step 1: Open Access, but do not open database. Click on File.
Step 2: Point the cursor to Info and then click on Compact and Repair Database.
Step 3: Now in the Database to Compact From dialog box, browse and select the database that you want to compact and repair.
Note: Make sure that nobody is using the database file, or else the compact and repair utility will fail.
If anyone using the database file then you can’t perform the compact and repair operation. Because, when you run the compact and repair operation, no one can access the database file.
Compact And Repair A Database That Is Not Open
Note: If users are at present using database file, you can’t execute compact and repair operation. While you operate compact and repair operation, no one can utilize database file.
- Start Access, but don’t open database.
- Point Info, and click Compact and Repair Database.
- In Database to Compact From dialog box, steer to and double-click database that you wish to compact and repair.
You may also like:
How To Automatically Repair Corrupt Access Database?
There are situation occurs when you cannot compact and repair Access Database to recover or repair up your access database file. In such situation you need to approach for the Access Repair And Recovery Tool as it is most appropriate tool for fixing up any corruption issue occurred in your Access Database.
If you are unable to apply the above given manual methods due to any reason. And want to get rid of MS Access Database corruption issue then approaching for this Access Repair & Recovery tool is the best option. This recovery software is one of the best ways to get rid of any kind of errors and restore your damaged database without using any backup.
Steps To Repair And Recover MS Access Database:
Try this inbuilt MS access tool to repair corrupt Access Database before trying any other fixes. As in most case this works great to fix such related corruption issue.
Now you must have got clear idea on what this compact and repair actually works for. So, use this tool to avoid common Access Database mistakes and also to resolve corruption issue. But if in case won’t work for your Access Database issues then also you have the option i.e Access Repair And Recovery Tool. And Don’t forget to share your experiences in our comment section.