I am trying to set up security for a multi-user database.
I want to set up a new workgroup for this database but can't fathom how to create the relationship between a specific database and a specific workgroup (if this can be done).
Everytime I set up a new workgroup it is used for all of my Access applications as is the case for any users that join the workgroup. How can I get round this so that users point to their workgroup when using any other database but the new workgroup when using the multi-user database?
Finally, is there a way of programatically joining members to a workgroup rather than them having to use the workgroup administrator?
I want to set up a new workgroup for this database but can't fathom how to create the relationship between a specific database and a specific workgroup (if this can be done).
Everytime I set up a new workgroup it is used for all of my Access applications as is the case for any users that join the workgroup. How can I get round this so that users point to their workgroup when using any other database but the new workgroup when using the multi-user database?
Finally, is there a way of programatically joining members to a workgroup rather than them having to use the workgroup administrator?
