In Security, Workgroup Administrator Add Check Box to always point

27 Jul 2006 10:53 PM

cjman

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/community/en-us/default.mspx?mid=849ce038-5ba6-4a83-9b56-082ba03b08e1&dg=microsoft.public.access.security

28 Jul 2006 1:25 PM

Joan Wild

cjman wrote:

> 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.