connect to access using password

K

kalle

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Coonect to access with password 2
Exporting data with vba from Excel to an Access 2007 db with password 8
How to Open a Password encrypted .accdb 0
How to copy data from an excel cell into a field in access table 0
ADO retrieval from close workbook-data type issue 2
Upload Excel data to Access error 1
HELP: Syntax error (missing operator) Query Expression 1
How to use more than one databases in a macro 4

Top