Wednesday, May 30, 2012

Access 2007: File Size Stays The Same After Deleting Records

Problem:  An Access database file has gotten large, so you decide to delete many records to reduce the file size.  After doing so, however, the file size stays the same.

Solution:  Compact and repair the database.

1)  Go to the Office button in the upper-left.
2)  Go to Manage and select "Compact and Repair Database".

Your database will now be a smaller size, sometimes even if you didn't delete any records. 

To make this automatic:

1)  Go to the Office button in the upper-left and click the "Access Options" button.
2)  Select "Current Database" from the left-hand menu.
3)  Check the box "Compact On Close" and click OK.

No comments:

Post a Comment