Home  |  About  |   Search   

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

RunCommand Constants

Terms of Use


 

Modules: Access 97 Compactor Addin

Author(s)
Dev Ashish

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), All Rights Reserved

Download  Download Compactor.Zip (size: 60,108 bytes)

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.


1998-2009, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer