Compact and Repair Using Scheduled Tasks

K

Kenny G

Access 2007

Hello,

I am currently scheduling Access databases for compact automatically using
the XP Scheduled Tasks are under the Control Panel. The databases compact
nicely but there remains two problems a .ldb is left and Access remains open.
I'd like to close those databases after the automatic compact. Is there
something I need to add to the run command line to close the database?

\\sharedir\UHS-QPI\uhs-qpi\ClinicalQualityDB\ClinicalQuality.mdb /compact

I appreciate your input.
 
J

John W. Vinson

Access 2007

Hello,

I am currently scheduling Access databases for compact automatically using
the XP Scheduled Tasks are under the Control Panel. The databases compact
nicely but there remains two problems a .ldb is left and Access remains open.
I'd like to close those databases after the automatic compact. Is there
something I need to add to the run command line to close the database?

\\sharedir\UHS-QPI\uhs-qpi\ClinicalQualityDB\ClinicalQuality.mdb /compact

I appreciate your input.

I always include the Access executable in the command line:

%Programfiles%\Office11\msaccess.exe "\\server\path\database.mdb" /compact
/repair /wrkgrp "\\server\path\database.mdw"

The wrkgrp can be omitted if the database isn't secured.
 
K

Kenny G

John,

Thanks - that did it.
--
Kenny G


John W. Vinson said:
I always include the Access executable in the command line:

%Programfiles%\Office11\msaccess.exe "\\server\path\database.mdb" /compact
/repair /wrkgrp "\\server\path\database.mdw"

The wrkgrp can be omitted if the database isn't secured.
 

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


Top