Connect to Workgroup Secured .MDB (1 Viewer)

[hi there]

hi all,

i'm not sure if this is the correct forum, so i apologize if this is in the wrong place, but here goes anyway. i think this is an MS Access rather than a .NET question but I could be wrong.

i'm trying to connect a .NET web form to an MS Access backend that has workgroup security. for testing purposes i created my ADO.NET connection object including the User ID and Password name value pairs for a valid workgroup login.

i'm getting the following error when trying to open the connection.

"Cannot start your application. The workgroup information file is missing or opened exclusively by another user."

has anyone tried to connect an outside FE application to a workgroup secured MS Access backend .MDB file?

i get no problems when connecting to an unsecured .MDB backend.

any ideas?

thanks.

 

[hi there]

do you have to use a System DSN that points to the workgroup (.mdw) file?

i tried that and i'm still having problems but i wonder if i'm on the right path?

 

[gemma-the-husky]

perhaps you still need to join the workgroup

try start - run - wrkgadm, then join the workgroup. Perhaps this will solve your problem. You will probably need to go back to system.mdw after using the dbs.