In Security, Workgroup Administrator Add Check Box to always point

[Guest]

In Tools, Security, Workgroup Administrator there should be a yes or no box
to always point to or find the security workgroup that is listed there or an
error occurs telling the person to join the appropriate workgroup or the
Database can't be opened. This would solve many of the security problems
listed in many forums and is a fairly simple solution to many of the woes of
Access Security. For example, I create a new workgroup named securityDBName.
The Database finds this securityDBName on the server at S:\securityDBName or
the database does not open. The FE or the BE.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...ba03b08e1&dg=microsoft.public.access.security

 

[Joan Wild]

In Tools, Security, Workgroup Administrator there should be a yes or
no box to always point to or find the security workgroup that is
listed there or an error occurs

That's how it works now.

telling the person to join the
appropriate workgroup or the Database can't be opened. This would
solve many of the security problems listed in many forums and is a
fairly simple solution to many of the woes of Access Security. For
example, I create a new workgroup named securityDBName. The Database
finds this securityDBName on the server at S:\securityDBName or the
database does not open. The FE or the BE.

A workgroup isn't tied to a mdb file, just to a session of Access.

None of it matters, since they've removed security from the next version.