Database Utility - Compact and Repair Database

M

Mark

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

If not VBA then VB.net?

Thanks, Mark
 
P

Peter De Baets

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
 
Top