How can I connect to an Access file with a security password through an Excel application? The code below connect to an Access file without a password. If I put a password in the Access file, I can´t connect just putting the user and the password (.Open ArquivoAccess, "user", "password").
Public ConexaoAccess As New ADODB.Connection
Function Func_ConexaoAccess(ArquivoAccess As String) As Boolean
Set ConexaoAccess = New ADODB.Connection
Func_ConexaoAccess = False
.Provider = "Microsoft.Jet.OLEDB.4.0"