Home  Fees/Services  Access Examples  Tutorials  Access Download  Articles  Search  Forums  Contact  Privacy  Links
Application Object Examples
Compact and Repair VBA Code

Visual Basic Application Objects

 





Access Error
AddToFavorites
BuildCriteria
CloseCurrentDatabase
CodeDB
CompactRepair
ConvertAccessProject


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.

CompactRepair Syntax:

Expression.CompactRepair (SourceFile, DestinationFile, LogFile)

Where:

Expression is a variable of type 'application' or the word application.

Sourcefile is full path and filename of the database to be compacted.

DestinationFile is the full path and filename of the resulting database file.

Example:

Application.CompactRepair("c:\mydbs\database.mdb","c:/mydbs/database_backup.mdb",true)

The compact repair command is of marginal usefulness because you can't compact/repair the currently opened database.








A Blue Claw Database Design Article:

Computer Disaster Recovery Planning
 





Blue Claw Database Design Downloadable Tutorial:
Access Report Banding  





A Blue Claw Software Design Template:

HOA Software Template
 



Contact Information

Copyright 2000-2017 Blue Claw Database Design