Connection String to Secured Database

  • Thread starter Thread starter Greyhound
  • Start date Start date
G

Greyhound

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
attempt:

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???
Thanks...
 
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.
 
Back
Top