This is especially true for databases where you are adding and removing a lot of data each time.

To fire up the automatic compact, open your Access file and go to Tools \ Options.

Now each time the database is opened it will automatically compact the data when you close Access.

Quick Tip: Automatically Compact Access Databases

/wordpress/wp-content/uploads/2007/05/WindowsLiveWriter/ManageDatabaseSizeAccess20022003_B661/Database%20Size.png