Admin User vis-a-vis Multiple MDW's

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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.
 
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
 
Back
Top