When to Compact & Repair your MS Access database?
If you are an MS Access user, you must have heard about the 'Compact & repair' utility but do you know the real purpose of this command. It is very important to understand when and why to use this command. Why Run Compact & Repair Utility on the MS Access database? When you add or update data in your database, the size of database file also continue to grow and at one point it becomes too large to manage. Actually when you delete a record from your database, the space that your record has occupied is not released for reuse automatically. It will continue to exist in your database as waste space until and unless you compact the database. Waste space may degrade the performance of your database. To avoid these issues you must compact your database at regular intervals.