How to open an Access Password protected database through ADO's

[Dinesh_MS]

I want to know how to open an Access password protected database through ADO's

Thank You.

[SysAdmin2]

Set cnADO = New ADODB.Connection

cnADO.Provider = "Microsoft.Jet.OLEDB.3.51"
cnADO.Properties("Jet OLEDB:Database Password") = "PASSWORD"
cnADO.Properties("Data Source") = "C:\Example.mdb"

cnADO.Open

[Lafor]

That will work if he/she has the password...

[Dinesh_MS]

Thanks for the reply.
I found that on the Microsoft's Knowledge Base. But i got an error when i gave it as part of a property just as in the example, but worked fine when i gave it in the connection string.