-
I want to know how to open an Access password protected database through ADO's
Thank You.
-
Example
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
-
...
That will work if he/she has the password...
-
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.