As I am trying to learn Access security, it seems that there is only one
'Admin' user per Access installation. And that this Admin user can only
belong to one workgroup at a time. Is this correct? If so, is there a way
to maintain and use multiple workgroups (MDW's) on the same PC without
running the Workgroup Administrator app each time and switching the Admin
user's membership?

Thanks Again,
Tom

Tom Glasser wrote:
> As I am trying to learn Access security, it seems that there is only
> one 'Admin' user per Access installation. And that this Admin user
> can only belong to one workgroup at a time. Is this correct? If so,
> is there a way to maintain and use multiple workgroups (MDW's) on the
> same PC without running the Workgroup Administrator app each time and
> switching the Admin user's membership?
>
> Thanks Again,
> Tom

Actually the unique identifier for the default user "Admin" is identical in
all MDW files. All that varies from one MDW file to another is what groups
he belongs to and what (if any) password he has assigned.

You can create a shortcut that specifies a specific workgroup as a command
line argument to use different MDWs without messing with your default. This
is what most developers do. The target looks like...

"Path to MSACCESS.exe" /wrkgrp "Path to MDW file"

The above would simply open Access. You can also add a path to a specific
file name in the shortcut if desired and can even specify the UserName and
Password. There is a help topic that descroibes all of the possible command
line arguments and how to use them.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Further to what Rick says: it is difficult or impossible for most users
to apply security propely, unless you follow a detailed list of wrtten
instructins - adding and omitting nothing.

The slightest mis-step can cause your database to be insecure. Hence
the number of posts that say, "I secured my database, but anyone else
can open it on their PC, bypassing my security!"

Try the Access Securty FAQ (often referenced in this newsgroup), or
check the regular posters' replies for suitable links.

HTH,
TC