Can somebody tell me how to connect to a secured Access97 database with ADO please.
Printable View
Can somebody tell me how to connect to a secured Access97 database with ADO please.
This is what your connection string should look like when connecting to a database with the database password set.
cnQ.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=" & App.Path & "\MyDbase.mdb;" & _
"Mode=Read|Write|Share Deny None;" & _
"Persist Security Info=True;" & _
"Jet OLEDB:Database Password=MyPassword"
If you are connecting to a database using Access Workgroup information you'll have to do it on the open event.
cnQ.Open myConnectionString, myUserName, myPassword