Provide database password to automatically compact database

T

Tran Hong Quang

Hi,
I have a database protected by database password and my own workgroup file.
Currently, I am using below command to compact my database (of course it is
not being opened):

Shell ("MSACCESS.EXE /compact /runtime /user MyAccount /pwd MyPassword
/wrkgrp """ & "C:\Accounts.mdw" & """ """ & strPathToDatabase & "")

As you can see, I can provide account and password to logon the workgroup.
But it still stop and ask me to manually provide Database password.

Is it possible to provide Database Password automatically ?

Thanks
Tran Hong Quang
 
Top