Access CompactRepair Method Example
CompactRepair Method - Compacts/repairs the specified
database (.mdb) or Microsoft Access project (.adp) file.
Returns a Boolean - true
if the process was successful.
Expression.CompactRepair (SourceFile, DestinationFile, LogFile)
Expression is a variable of type 'application' or the word
Sourcefile is full path and filename of the database to be compacted.
DestinationFile is the full path and filename of the resulting
The compact repair command is of marginal usefulness because you can't compact/repair
the currently opened database.