Compacting and repairing a Microsoft Access database

When you delete data and objects, such as tables and queries from an Access database, the database may become fragmented and take up more space than it should. If your database suddenly seems very large, this may well be the problem. Compacting the database will reduce the amount of space it takes up on the disk and will also repair the database if it is damaged.

To compact and repair a database if using Microsoft Access 2003 or earlier:

  1. Click Tools – Database Utilities.
  2. Click Compact and Repair Database. If the database is open, the compacting process will start. If no database is currently open, select the database which you want to compact, then click Compact.
  3. Select where on the system the compacted database should be stored and give it a suitable name. If you leave with same name and filepath, the compacted database will overwrite the existing one.
  • If you need to stop the compacting process at any time, press Ctrl + Break or the Esc key.

If you want the database to be compacted and repaired each time you close it, click Tools- Options – General and activate the Compact on Close option.

If using Microsoft Access 2007:

  1. Open the database you wish to compact.
  2. Click the Office button.
  3. Click Manage – Compact and Repair Database.

If using Microsoft Access 2010:

  1. Open the database you wish to compact.
  2. Click File – Manage – Compact and Repair Database.

Find out more about our Microsoft Access training courses Sydney, Australia or our Microsoft Access training courses London, UK.

About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Microsoft Access, Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010, Uncategorized and tagged , . Bookmark the permalink.

One Response to Compacting and repairing a Microsoft Access database

  1. Thanks for finally writing about >Compacting and repairing a Microsoft Access database | ifonlyidknownthat <Loved it!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s