Access 2007 compact database

  • Thread starter Thread starter Tony WONG
  • Start date Start date
T

Tony WONG

there are some over night schedule to compact databases by "access
n:\abc.accdb /compact"

i find if the database is stored at network drive, the database cannot be
compact by command mode or Access window application.

now i have to copy them to local drive and then compact and then copy back
to network drive.

Thanks.

tony
 
Hi Tony,

Have you tried going in using VBA?
Maybe take a look at the DBEngine.CompactDatabase Method. You are still
copying the file but you can automate the process, assuming you have the
necessary permissions.

Hope this helps,
Gordon
 
Back
Top