[AccessD] DBEngine.CompactDatabase - Supplying Password argument for currently open db.

For 97 this was easy
http://www.trigeminal.com/code/DatabasePassword.bas


A.D.TEJPAL wrote:

>    For making a back-up copy of currently open FE and then compacting this back-up copy, using  DBEngine.CompactDatabase method, database password if existing, has to be passed as the last argument, e.g.
>
>    DBEngine.CompactDatabase "SourceFilePath", _
>                "DestinationFilePath", , , ";pwd=xyz"
>
>    Could there be a way to get the password for currently open db,  without prompting the user for it ?
>
>    Note - Application.CompactRepair method seems ruled out as it does not have any password argument in its syntax and instead prompts the user for it.
>
>TIA
>A.D.Tejpal
>---------------
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada