Trouble with a Access Db w/password......

[Qwick Miller]

When I set a password to my access db. myCon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db.mdb;Password=password"); myCon->Open(); I get a exception error. "The workgroup information file is missing or opened exclusively by another user" ..but when I remove it, it open ok. What other param's I need to set in order to open a password protected access db?

[jonathan15]

if its the database password and not tied to specific users then try the following connection string "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & sFullPath & ";Mode=ReadWrite;Persist Security Info=False; Jet OLEDB:Database Password=" & sPassword Where sFullPath is the full path and filename of the db and sPassword is the db password. Jon