97-How can I compact a database using code while the database is open?

[ruthcali]

in my database, i am daily deleting and importing tables.&nbsp;&nbsp;i desperately need to compact!&nbsp;&nbsp;<br><br>i am using Access97.&nbsp;&nbsp;i can easily go to Tools, Database Utilities, Compact Database, but i want to happen when i close my form. <br><br>i don't want the name of the database to change and i want to do it while the database is open.&nbsp;&nbsp;<br><br>is this possible?

 

[kathryn]

Check out the compactor add-in available from <br><br><A HREF="

http://www.mvps.org/access/resources/downloads.htm"

TARGET="_new">

http://www.mvps.org/access/resources/downloads.htm</A><br><br>I

have gotten a lot of good code and tips from there!

 

[ruthcali]

wow, that download seems perfect. <br><br>It says: &quot;Make sure that you read the AppNotes first&quot; but when i click on the AppNotes hyperlink, i get &quot;this page cannot be displayed&quot;.&nbsp;&nbsp;are the AppNotes important? do you know/remember?

 

[ruthcali]

uh oh, when i try to use the add-in, i get a message &quot;invalid database name. compactor will terminate.&quot;<br><br>First i downloaded and unzipped the compactor.mda file. then, i opened my database, selected File, Get External Data, Import.&nbsp;&nbsp;then i chose the compactor.mda file and chose 'Select all'.<br><br>so it added some modules, macros and a form to my database.<br><br>but, closing and then re-opening the database causes the error message. <br><br>did i do something wrong? i have never used an add-in before.

 

[kathryn]

To use an add-in, you must copy the compactor.mda file to your \program files\microsoft office\office\addins\ directory.&nbsp;&nbsp;Then go to Tools...AddIns and you will see a list of available addins, including Add-In Manager.&nbsp;&nbsp;Choose Add-In Manager and click on the compactor addin.<br><br>Click on Tools...AddIns again and the compactor should show up in the available add-in list.<br><br>Let me know if you need more.