Connection String to Secured Database



I need to connect to a secured database. A workgroup has been created and i
am a member of the workgroup and have admin access to the database. I cannot
get the connection string correct to connect. The database is on our 'W'
drive. My user id gets me into the database with no password. Here is my

string cnStr = "Provider=Microsoft.Jet.OLEDB.4.0; " +
"Data Source=w:\\day_hospital\\replica_dayhospital.mdb; " +
"Jet OLEDB:System Database=W:\\Day_Hospital\\DayHosp_Secured.mdw, uid, ";

The error I get is 'Cannot start your application. The workgroup
information file is missing or opened exclusively by another user.'

Any Suggestions???


I agree that this site is helpful. They show a connection string with a
'System' workgroup but not a workgroup that the administrator creates. I
have tried to adapt the syntax but I am not having any success.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question