Microsoft Office Tutorials and References
In Depth Information
Session 1.2
Figure 1-18
Compacting a database
before compacting
after compacting
disk
database
LEGEND
active
database
element
deleted/replaced
database
element
When you compact a database, Access repairs the database at the same time. In many
cases, Access detects that a database is damaged when you try to open it and gives you
the option to compact and repair it at that time. For example, the data in your database
might become damaged, or corrupted, if you exit the Access program suddenly by turning
off your computer. If you think your database might be damaged because it is behaving
unpredictably, you can use the “Compact and Repair Database” option to fix it. With your
database file open, point to the Database Utilities option on the Tools menu, and then
choose the Compact and Repair Database option.
Compacting a Database Automatically
Access also allows you to set an option for your database file so that every time you close
the database, it will be compacted automatically.
Reference Window
Compacting a Database Automatically
Make sure the database file you want to compact automatically is open.
Click Tools on the menu bar, and then click Options.
Click the General tab in the Options dialog box.
Click the Compact on Close check box to select it.
Click the OK button.
You’ll set the Compact on Close option now for the Seasonal database. Then, every
time you subsequently close the Seasonal database, Access will compact the database file
for you. After setting this option, you’ll close the database.
Important: Because Access copies the database file and then compacts it on the same
disk, you might run out of storage space if you compact a database stored on a floppy
disk. Therefore, it is strongly recommended that you set the Compact on Close option
onlyif your database is stored somewhere other than a floppy disk. However, if you must
 
Search JabSto ::




Custom Search