I still don't know how to connect ACCESS 2010 by ADO

[henry]

Here is my connection string

mydata = ThisWorkbook.Path & "\WDataBase3.accdb"
With Cnn
.Provider = "Microsoft.ACE.OLEDB.12.0"
.Properties("Data Source") = mydata


.Properties("Jet OLEDB:database Password") = "123456"
.Open
End With

I am trying to connect ACCESS 2010 from EXCEL 2010 VBA by ADO.
The problem is always NOT A VALID PASSWORD pop-up, but the password is correct.
I have searched a lot of webs, some of which suggest something about front-end and back-end password. but I don't know what that means. what shall I do exactly? I don't know if there is difference between ACCESS 2010 and ACCESS 2007？

[ajetrumpet]

try searching google on "ado not a valid password"

is it possible that you're not running 12.0? your profile says that you're running Access 2010, and version 12.0 is Access 2007.