Microsoft KB Archive/197591

= ACC2000: Database Doesn't Shrink Automatically When Object Is Deleted =

Article ID: 197591

Article Last Modified on 7/15/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q197591



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
When you delete an object in Microsoft Access, the size of the database remains the same or gets larger after the deletion.



CAUSE
Deleting objects from a database does not automatically cause the database to shrink in size. This is because, when an object is deleted, the space that it occupies is marked as available. However, the size of the database does not shrink.



RESOLUTION
If you are deleting objects from a database and you want the database to return to its previous size, you should compact the database.

One of the new features in Microsoft Access 2000 is compact on close. When you use this feature, Access automatically compacts the database each time that you close it. To use the compact on close feature, follow these steps:
 * 1) On the Tools menu, click Options.
 * 2) Click the General tab.
 * 3) Click to select the Compact On Close check box, and then click OK.



Steps to Reproduce Behavior

 * 1) Open a new database in Microsoft Access.
 * 2) Import the Orders table from the Northwind.mdb sample database.
 * 3) Close the database and note the size of the .mdb file.
 * 4) Reopen the database and delete the Orders table.
 * 5) Close the database, save the changes, and then note the size of the .mdb file. The size of the database has not decreased and, in some cases, may have increased.

