Sub OpenDB()
Dim MinhaPassword As String, strDbName as string
Dim objAccess as Access.Application
MinhaPassword = "xpto"
strDbName = "c:\SeuBanco.accdr"
Set db = objAccess.DBEngine.OpenDatabase(strDbName, False, False, ";PWD=" & MinhaPassword)
objAccess.OpenCurrentDatabase filepath:=strDbName
End Sub