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

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