All databases keep defaulting to one workgroup

[Guest]

I want to make 2 workgroups, one for a very secure database, one for all the
other databases I have. Problem is, whichever workgroup I choose becomes the
default for all of them. How can I make it stop doing this?

Please note that I am not an IT professional, so I can't mess with stuff
outside of Access itself.

 

[Rick Brandt]

I want to make 2 workgroups, one for a very secure database, one for
all the other databases I have. Problem is, whichever workgroup I
choose becomes the default for all of them. How can I make it stop
doing this?

Please note that I am not an IT professional, so I can't mess with
stuff outside of Access itself.

YOU have a default workgroup, not your MDB files. If you make your default
workgroup one that requires a login (Admin user has a password) then you are
always prompted.

The trick is to keep System.MDB as your defqault for use with all your
non-secure files and then create shortcuts for your secured ones that specify a
non-default workgroup. The target for such a shortcut would look like...

"Path to MSAccess.exe" /wrkgrp "Path to workgroup" "Path to MDB"