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.
Compacting a database is much different than repairing. Here is an explanation of why both should be done.
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.
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.