Connection String to Secured Database

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

Greyhound

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

Top