[ExcelVBA] Access connection using VBA Excel - code. accuses Invalid Password

 

Hy,
I have a code that do not work because it accuses invalid password despite I'm using the correct password
Look the code:

Dir = ActiveWorkbook.Path
Myconn = Dir & "\RH_Access.accdb"

'Faz a conexão com o banco de dados
Set cnn = New ADODB.Connection
With cnn
.Provider = "Microsoft.ACE.OLEDB.12.0"
.Properties("data source") = Myconn
.Properties("User ID") = "Admin"
.Properties("Jet OLEDB:Database Password") = "daniel"
.Open
End With

Can somebody help me to make it work please?
Daniel

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 3

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___