|Access Developer Reference|
Compacts and repairs the specified database or Microsoft Access project (.adp) file. Returns a Boolean; True if the process was successful.
expression.CompactRepair(SourceFile, DestinationFile, LogFile)
expression A variable that represents an Application object.
|SourceFile||Required||String||The full path and filename of the database or project file to compact and repair.|
|DestinationFile||Required||String||The full path and filename for where the recovered file will be saved.|
|LogFile||Optional||Boolean||True if a log file is created in the destination directory to record any corruption detected in the source file. A log file is only created if corruption is detected in the source file. If LogFile is False or omitted, no log file is created, even if corruption is detected in the source file.|
The source file must not be the current database or be open by any other user, since calling this method will open the file exclusively.
The following example compacts and repairs a database, creates a log if there's any corruption in the source file, and returns a Boolean value based on whether the recovery was successful. For the example to work, you must pass it the paths and file names of the source and destination files.
|Visual Basic for Applications|