opening password protected mdb in VB/VBA: DAO,ADO & OpenCurrentD

[sanpo]

If an Access database is password protected with say password ‘abcd’, what
will the syntax for opening a password protected mdb through VB / VBA:
1. in case of DAO
2. in case of ADODB
3. in case of OpenCurrentDatabase of Access