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.
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