Using the Compact/Repair Feature in Access
NEW: Compact with VBA Video
NEW: Access Compactor Template
In this tutorial you will learn how to use the CompactRepair Function.
Reasons to compact regularly: if you do a lot of Import/Export.
Tools > Options
General and checking Compact on Close.
Options -> Current Database -> Compact on close.
Application.CompactRepair sourceFile, destinationFile
Application.SetOption "Auto compact", True
I personally do NOT like automatically compacting.
I've seen databases get corrupted this way.
I like to make it a calendar item for myself once a week to (a) backup, and then (b) compact.
Access Tips. Search
You can find more about this by
searching the website. MS Articles
By: Alex Hedley
to sign up for more Click here FREE tips