Compacting Databases

[Chuck L]

I would like to compact a database with a macro as part of
a series of actions in that macro. I would like to do
this as if I had selected the Tools -> Database Utilities-

Compact Database option on the menu bar. I know there is

a way to do this by writing code, but I am unfamiliar with
writing code. Is there a way to do this in the macro? I
tried the Run Command action in the macro and it prompts
me. I need it to compact with no prompts to the same
database.
If the only way to do it is to write code, what is the Sub
Procedure?
I've been working with this for a couple of hours with no
headway. I appreciate any help that you can give.
Thanks.

 

[Steve Schapel]

Chuck,

Sorry, this is not directly possible in macro or code. You can only use
macro or code to compact a closed database. Therefore to compact the
current database you need to close it, and open another one, and then
use code from the other database to compact the original. The
information at http://www.trigeminal.com/lang/1033/utility.asp?ItemID=8
will be of relevance.