When i open db (database password) through VBA code as below
Dim cNN As New ADODB.Connection
'For Testing purpose
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\krishna\Access\ms.mdb;"

If cNN.State <> 0 Then Exit Sub
cNN.ConnectionString = connStr
cNN.Open , , "ms"

it display message

"can not start your application, The workgroup information file is missing or opened exclusively by another user"

1. how can this be resolved? if code has any syntax error??
2. If db is set password would it be shared by code, as my application is client server application with db placed at server!!!

so many question....