Join workgroup 2007

[Matt]

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.

 

[Brendan Reynolds]

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.

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

DoCmd.RunCommand acCmdWorkgroupAdministrator

 

[Matt]

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

 

[Mike]

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.

 

[Douglas J. Steele]

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.