Access 2007 compact database

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
 
G

gllincoln

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compact and Repair Using Scheduled Tasks 2
Compact Database 3
Easy way to compact an Access 2003 database 1
Access 2007 - compact database 2
Access 2007 'Compact & Repair' not reducing size on networked driv 5
Access 2007 Compact problems 2
Compacting Access database 2
Compact and Repair function creates a new mdb file, Database 1, 2, 9

Top