INFORMATION PROVIDED IN THIS DOCUMENT AND THE COMPACTOR UTILITY ARE
PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED. THE
USER ASSUMES THE ENTIRE RISK OF RUNNING THIS SOFTWARE.
Ó Dev Ashish and Terry Kreft (1998-2002), Peter Doering (2013)
All Rights Reserved
Download Compactor.Zip (Access 97) (size: 60,108 bytes)
Download Compactor2003.Zip (Access 2007, 2010, 2013) (size: 26,533 bytes)
Update for Access 2007, 2010 and 2013: The Compactor has been converted by Peter Doering.
Compactor2003 has been tested successfully on Access 2007, 2010 and 2013. Installing Compacter.mda as add-in on operating systems with User Account Control (Windows Vista, Windows 7/8) will fail with message “You do not have sufficient security permission to install this Add-in. Contact your system administrator for assistance.” In this case start Access by right-clicking on MSAccess.exe and select Run as administrator. This is necessary even when logged on as administrator. Then, within Access, repeat the installation as add-in. Remember to add the add-in folder to the trusted locations list.
For those of you who didn't want to install the VB 5 mdbCompact utility, here's an
Access 97 addin to do the job.
The Compactor uses Automation through a new instance of Access to compact the current
database. A command line parameter allows you to specify whether to reopen the
database or quit the Access instance.
The Compactor utility has been made into an Add-in because it can be called:
- in code, if it's in the Office directory, with
- as a referenced database with
All previous code has been replaced by a single entry point function, DoCompact,
which accepts one argument, True to reopen the database, or False
to close the Access instance.