Configuring multiple access db's on 1 cpu

[Clay]

I have created 4 databases for our HR division at work.
All 4 databases reside on our network -- and user's have
shortcuts to each database on their desktop. My problem
is that in 3 of the databases, I have created security
files and placed them in the same folder as the
database. Each time a user switches from one database to
the other, they must join the correct security file via
the Workgroup Administrator. THIS CREATES CONFUSION FOR
MY USERS - as some are not "computer literate".

MY QUESTION:
How can I set the databases up to read the appropriate
security file prior to opening -- without having
to "join" the appropriate workgroup through the workgroup
administrator? Is there some vba coding I can use -- and
if so, where do I put it and what is it? Or can I
somehow tie them together by the shortcut on the desktop?

PLEASE HELP ME HELP MY USER'S AVOID MASS CONFUSION!
Thank You in advance.
Clay

 

[John Spencer (MVP)]

Use the command line switch in your shortcut.

/wrkgrp workgroup information file

Check the online help

Specify command-line options for a shortcut

Try using the index keyword "Switch" and then scan the list of items.