View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kalle kalle is offline
external usenet poster
 
Posts: 27
Default connect to access using password



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 ***