Compact an Access database or Access project automatically when you close it

Microsoft Access can automatically compact a Microsoft Access database or Microsoft Access project every time you close it.

1. Open the Access database or Access project that you want Microsoft Access to compact automatically.
   
   
2. On the Tools menu, click Options.
   
   
3. Click the General tab.
   
   
4. Select the Compact On Close check box.

Note   Compacting does not occur if you close a multiuser (shared) database while another user has it open.