Compacting+the+size+of+a+database+file

Home / software / microsoft access

As mentioned already, once you have created a database file, it occupies a certain amount of memory space that can grow or shrink without your direct intervention: When you add an object to the database, the database's file grows as needed. When you remove an object, the memory space it was occupying is left empty. This also applies when you keep removing objects: The computer is supposed to recuperate the space those previous objects were using. Unfortunately, that is not always the case. Most of the time, that space is left empty but cannot be accessed by the computer (by other applications). This means that the memory space cannot be made available to other applications. To recover this memory space, you can compact the database. When this is done, the file is shrunk to occupy only the necessary amount of space and free the unused sections: To compact a database, you have many options. To compact and repair the database that is currently opened, and to compact it only once, on the Ribbon: code format="sectover"
 * Compacting and Repairing a Database ||
 * Click File. In the middle section, and click Compact & Repair Database:

code The database would be compacted behind the scenes. To compact a database every time you close it, click File and click Options. In the Access Options, in the left list, click Current Database. In the right list, click the Compact on Close check box: And click OK.
 * Click Database Tools and click Compact and Repair Database [[image:http://www.functionx.com/access/buttons/carp1.gif width="89" height="66" caption="Compact and Repair Database"]]