[Access 2000]

Regularly compacting an Access database allows it to run more efficiently by reducing the file size and defragmenting the data. However, most users forget to do this on a regular basis. So, by using the Compact On Close feature, you can forget about having to do this and let it do it on its own. Here's how:

1. Select Tools/Options from the menu bar
2. Click on the General tab
3. Select the Compact On Close check box
4. Click OK

Access will automatically compact and repair the file if the database will be reduced by at least 256 kilobytes when you close it.

Note: This setting needs to be activated on a file-by-file basis.