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.