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...

Try this website connectionstrings.com. It's very helpful.

"Greyhound" wrote:

> 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.

"Andrew" wrote:

> Try this website connectionstrings.com. It's very helpful.
>
> "Greyhound" wrote:
>
> > 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...