find out which group a user belongs to

[tomlander]

In VBA, can I find out what group/groups a user belongs to?

Thanks.

 

[FancyPrairie]

The following code will print out the groups the user "YourUserName" is assigned to.

    Dim wsp As Workspace
    Dim i As Integer

    Set wsp = DBEngine.Workspaces(0)
    
    For i = 0 To wsp.Users("YourUserName").Groups.Count - 1
        Debug.Print wsp.Users("YourUserName").Groups(i).Name
    Next i