Join workgroup 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matt - 26 Mar 2008 15:21 GMT

How the heck do you join a workgroup in 2007? I just upgraded and it tells
me that I don't have permission to access my own security.mdw file. I am the
creator/owner of all associated files with our database as it is still under
construction. I added myself to the users list etc., but I don't see how
that would help with my old security file (it didn't). Any help would be
greatly appreciated.

Reply to this Message

Brendan Reynolds - 26 Mar 2008 16:00 GMT

> How the heck do you join a workgroup in 2007? I just upgraded and it
> tells
[quoted text clipped - 5 lines]
> that would help with my old security file (it didn't). Any help would be
> greatly appreciated.

You can launch the Workgroup Administrator dialog box by entering the
following line of code in the Immediate window ....

DoCmd.RunCommand acCmdWorkgroupAdministrator

Signature

Brendan Reynolds

Reply to this Message

Matt - 26 Mar 2008 16:19 GMT

Thanks, that fixed me up! I appreciate the quick response and the help.

> You can launch the Workgroup Administrator dialog box by entering the
> following line of code in the Immediate window ....
>
> DoCmd.RunCommand acCmdWorkgroupAdministrator

Reply to this Message

Mike - 17 Sep 2008 23:21 GMT

Why does Microsoft hide features from previous versions that we have become
accustomed to using? Why must we learn to use the same tool all over again?
This is frustrating. I hate Office 2007 because access to everything has
changed. I am an intermediate to expert user and this is such a time waster.
Why must we search google to find answers that should be in the help file for
the product. How could they exclude the Workgroup administrator from the help
file? They really must want us to stop using it.

> You can launch the Workgroup Administrator dialog box by entering the
> following line of code in the Immediate window ....
>
> DoCmd.RunCommand acCmdWorkgroupAdministrator

Reply to this Message

Douglas J. Steele - 18 Sep 2008 00:54 GMT

In this case, they may very well not have wanted it to be easily apparent.

The new ACCDB file format in Access 2007 no longer supports user-level
security. The only reason the abiity to work with the workgroup is there at
all is for when you're using MDBs.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Why does Microsoft hide features from previous versions that we have
> become
[quoted text clipped - 13 lines]
>>
>> DoCmd.RunCommand acCmdWorkgroupAdministrator

Reply to this Message