For the FE we normally use this :
Automatically compact and repair a database when it closes
You can select the Compact on Close database option if you want to automatically compact and repair a database when it closes.
NOTE: Setting this option affects only the database that is currently open. You must set this option separately for each database that you want to automatically compact and repair.
On the File tab, click Options.
In the Access Options dialog box, click Current Database.
Under Application Options, select the Compact on Close check box
WHAT ABOUT THE BE (BACK END)??????