connect to access using password
 

is the password actually password? thats a little odd.

"kalle" wrote in message
...


Hi!

I'm trying to connect to a access db that have a password but with no
luck.

I use this code

Set con = New ADODB.Connection
con.Provider = "Microsoft.ACE.OLEDB.12.0"
con.Open ThisWorkbook.Path & "\file.accdb", "", "password"

con.CursorLocation = adUseClient

What is wrong?

Thanks in advance

*** Sent via Developersdex http://www.developersdex.com ***

connect to access using password
 

No password is not the real password.
It is obviously something else.

The question is why it does not work. How to connect to an access
database that has a password?

I have the test locally on my computer and on the network but it makes
no difference.

*** Sent via Developersdex http://www.developersdex.com ***