Compact and Repair Using Scheduled Tasks

[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.

 

[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.

 

[Kenny G]

John,

Thanks - that did it.
--
Kenny G

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.