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?

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.

Show quoteHide quote

George W Schalles IV wrote:
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.

Allow Help Desk to Reset Passwords Without Full Admins Permissions
Necessary Permissions
Security restrictions and table linking
Login in dynamically
Drop Down on Table
secured database
Remove Security from Access
Lost My Permissions
Securing the Back-End
from mdb how to openForm a form in a referenced mde file