All DBs change to the same workgroup

[R Pociopa]

I have set up a database and so far all of the permissions, groups, users
etc. have been working fine. The only problem is, I have several databases
and when I assign one to a workgroup, all the rest change to that workgroup!
How can I make sure only the higher-security database has one workgroup, and
all the rest have a lower-security workgroup?

 

[Joan Wild]

Access uses a workgroup file (mdw) for every session - doesn't matter
whether your mdb is secure or not.

It ships with a mdw named system.mdw and uses that, silently logging you in
as 'Admin' user.

When you secure a mdb, you create a new workgroup file. Access made this
secure mdw your default. Use the workgroup administrator and rejoin
system.mdw as your default. That will require no login when you start
Access.

For the one secure mdb you have, launch it using a desktop shortcut which
uses the /wrkgrp switch to over-ride your default mdw *for just that
session*. The target would look like
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"