How To Compact And Repair A Database Automatically

Do you know you can repair your corrupt Access database automatically even when the database is closed? Yes, you can Compact And Repair a database automatically, whenever the database is closed.

Why you need to Compact and Repair your database

Compacting a database is much different than repairing. Here is an explanation of why both should be done.


Compact

When the data is updated and database's design change, its file also gets raised. Besides this sometime the Access creates hidden objects in order to perform certain tasks. Also when the database file gets deleted the disk space is not gets released.

Compacting the database helps in freeing up the unused space of the database which is captured by these objects. Compact operation doesn't actually compress the data but actually releases the unused space.


Repair

Database file can easily get corrupted and it is much common in multi-user environment. If a database file is shared over the network and multiple users work on the same database file, then there are chances of it to get corrupt.

When any access database file gets corrupt, Access marks it as corrupted database file. Well such file can be repaired by using the compact and repair process although some data may get missing after the repair process has completed.

So, here is the complete step on how you will repair your corrupt Access Database using the compact and repair process, even when the database is closed.

Steps To Compact And Repair A Database Automatically



1

With the database already open, tap to the file option from the top left corner of the database.

2

Now hit the Options button from the left menu.

3

  • This will open the Access Options dialog box.
  • Tap to the current database in the left menu.
  • After this check Compact on Close under Application Options.
  • Click OK.

4

After perform such procedures, a dialog box is displayed explaining that you must close and reopen the database for changes to take effect.

At last tap to OK option, then after closing your database reopen the database again.