Modules: Compactor Addin for Access 97, 2007, 2010 and 2013

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:

• from the add-in menu

• in code, if it's in the Office directory, with
        call application.run("Compacter.DoCompact", True|False)

• as a referenced database with
          Call DoCompact(True|False).

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.