CF_COMPACT

CF_COMPACT compact a MSAccess database.

Syntax

<CF_COMPACT 
    DATABASE="database name" 
    BACKUPDATABASE="backup database name"
>

DATABASE

Required. The fully qualified path to the database that needs to be compacted

BACKUPDATABASE

Optional. The fully qualified path for a backup of the database. If omitted, no backup is made.

Usage

Use CF_COMPACT to compact a MSAccess database remotely, bypassing the process of downloading, compacting and uploading. Compacting results in a more efficient database, both in speed and in size.
The following are prerequisits for the use of this tag:

<CFOBJECT> is enabled
<CFFILE> is enabled
The database is not locked
MSAccess is installed on the server

<CF_COMPACT> always resturns the variable compact_error. If this variable is 0, there are no errors encountered. If this variable is not zero, it is documented in the source what the error is.