Prevent all Access files from connecting to the same Workgroup?

[Guest]

I am trying to post an Access database to a common drive and have only it
join to a Microsoft Office Access Workgroup Information file. Unfortunately
all of my other Access databases are also joining with this same workgroup
information file. How do I prevent this issue?

 

[Douglas J. Steele]

Don't join Access to your "special" workgroup file. Instead, use a shortcut
that points to the correct workgroup file for that database that needs it,
and have Access join your standard system.mdw file.

 

[Rick Brandt]

I am trying to post an Access database to a common drive and have
only it join to a Microsoft Office Access Workgroup Information file.
Unfortunately all of my other Access databases are also joining with
this same workgroup information file. How do I prevent this issue?

Access files are not joined to a workgroup file "users" are. The workgroup
file is established when Access is launched, before a file is opened. If a
user opens Access without specifying a workgroup as a command line argument
then their default workgroup file is used (the one they "joined").

If you have made your default workgroup file one that has a password on the
Admin user then you are prompted to log in. At that point Access has no
concern over what file or files you might open. The prompt is driven
strictly by the workgroup file you are using for this session.

The standard way to deal with this is to leave your default workgroup as
System.mdw and to build special shortcuts for your secured files that
specify a non-default workgroup in the command line. Then you are only
prompted when you open the file using that shortcut while other non-secured
files can be opened without a prompt.