MSysUserMemberships query

[Mike Binger]

I am wondering if the query MSysUserMemberships is available to run from the .mdw file that would be open at the same time a database is open, ...or if there is another way to pull the group or group names for the user who has the database open. This isn't an immediate need but I have a vision to use an Autoexec macro which goes to a different form depending on the group the user is a member of. Thanks for any help! MIKE

 

[Joan Wild]

The security FAQ includes sample functions you can use to determine if a
user is a member of a group, or list the groups they are members of.
http://support.microsoft.com/?kbid=207793

--
Joan Wild
Microsoft Access MVP

I am wondering if the query MSysUserMemberships is available to run from

the .mdw file that would be open at the same time a database is open, ...or
if there is another way to pull the group or group names for the user who
has the database open. This isn't an immediate need but I have a vision to
use an Autoexec macro which goes to a different form depending on the group
the user is a member of. Thanks for any help! MIKE

 

[Mike Binger]

This will work just fine. Thanks! Mike

----- Joan Wild wrote: -----

The security FAQ includes sample functions you can use to determine if a
user is a member of a group, or list the groups they are members of.
http://support.microsoft.com/?kbid=207793

--
Joan Wild
Microsoft Access MVP

I am wondering if the query MSysUserMemberships is available to run from

the .mdw file that would be open at the same time a database is open, ...or
if there is another way to pull the group or group names for the user who
has the database open. This isn't an immediate need but I have a vision to
use an Autoexec macro which goes to a different form depending on the group
the user is a member of. Thanks for any help! MIKE