"Total
Visual Agent is a real find, a rare combination of ease of use, and bang
for the buck. In the end, no other competitor even comes close."
Thomas
Wagner, Product Review in MS Office and VBA Developer
|
|
Microsoft Access Database Compact and Repair to Minimize Corruption and Avoid Bloat (by
Access Version)
Provided by
Luke Chung, FMS President
Microsoft Access/Jet Databases Need to be
Periodically Compacted
File server databases like Access/JET MDB and
ACCDB files need to be periodically compacted
and repaired for optimal performance and to
minimize database corruption. Compacting also eliminates
database bloat that can occur as data is added
and deleted in the database. Here's a Microsoft Knowledgebase
article
that discusses some of the issues.
Microsoft
Access databases can be manually compacted from
the Access menu. Over the last
few versions of Access, the location of this
command has moved around. Here's a summary across versions.
Database Compact by Access Version
Microsoft Access 2010
From the Office button, choose Info, then select the Compact and Repair button on the right:
Microsoft Access 2007
From the Office button, select Manage and choose
the Compact and Repair menu item:
Microsoft Access 2003 and Earlier
Pre-ribbon, it was simply on the menu under: Tools, Database Utilities, Compact and Repair Database
Blog on this topic:
Microsoft Access Database Compact and Repair to Minimize
Corruption and Avoid Bloat
Additional Resources and Technical Papers
Microsoft Access Database Administrator Products
Schedule and Automate Database Compacts
Total Visual Agent manages an unlimited number of databases across your network and
schedule database chores in the middle of the night. Perform
compact, backups, data extracts, running macros, command lines, and
other tasks. Schedule events hourly, daily, weekly, monthly or just
one time. Complete audit trail with email notification if anything
goes wrong. Free Demo
|
Monitor Your Database in Real-Time
Total Access Admin lets you monitor
Access databases in real-time to see who's currently in it and when
they leave. It flags users who disconnect in a suspect manner which
may indicate a source of database corruption. It can also perform
tasks after everyone has exited such as compact.
Free Demo
|
|
|
