Database Utility - Compact and Repair Database

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Is there any way to run the Compact and Repair Database
Utility from VBA?

If not VBA then VB.net?

Thanks, Mark
 
See the CompactDatabase method.

Ex.:

DBEngine.CompactDatabase "Source path and filename", "Destination path and filename"

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com
 
Back
Top