Quote:
Originally Posted by apr pillai
Run Repairing/Compacting untility at least once in a week.
Take a Backup of the database before you run the above utility.
You must have exclusive access and Administrative privilages to run the Repairing/Compacting utility.
Access2007:
Click the
Microsoft Office Button 
, point to
Manage, and then, under
Manage this database, click
Compact and Repair Database
In older versions you can find this option under
Tools Menu.