MSysUserMemberships query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Mike Binger said:
I am wondering if the query MSysUserMemberships is available to run from
Click to expand...
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
 
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

Mike Binger said:
I am wondering if the query MSysUserMemberships is available to run from
Click to expand...
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
 
Back
Top