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

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

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
export excel data to access table using ADO 0
Import multiple Access Queries 0
Table Security in Access 2013 1
Access to Excel format 2
Upload Excel data to Access error 1
Export specific fields from access to Excel 0

Top