Are you referring to Access 2007? There is no Workgroup
administrator in the new format, because there is no security.
With the MDB format, it's a bit convoluted. Here's a Knowledge
Base article describing how.
http://support.microsoft.com/kb/918583
On first reading I found the wording of your answer confusing,
Arvin, though now on re-reading, I find that it's correct. Put
another way, what you said is:
1. for ACCDB, there is no workgroup administrator because ACCDB
format does not support Jet user-level security.
2. for MDB, the workgroup administrator is not as easily accessible
as it was in the previous version of Access (2003), where it was a
choice on one of the menus (I don't have A2002 installed on this
machine, so I can't tell whether that was added in A2002 or A2003).
The cited article gives instructions on how to launch it from within
Access.
Adding to what Arvin said, though, you might want to just search for
the workgroup administrator executable on your hard drive and create
a shortcut on your desktop (or in your Programs menu). This would
return you to the situation that pertained before the addition of
that menu choice on the Tools|Security menu.
But you should also consider whether you really want to muck around
with this instead of just specifying the workgroup in the shortcut
with which you launch your app.
