how to get groupname of curent user

[pramoc]

i have created group name using security group s and accounts in tools option.


how can i get the groupname of currentuser through code
Dim cat As New ADOX.Catalog
Dim grp As New ADOX.Group
Dim usr As New ADOX.User
plz help

[OBP]

See this article -
http://www.databaselessons.com/using-groups-in-access-security.php

[pramoc]

it is for dao
can u provide me same thing for ado

[OBP]

No, sorry I do not have it for ado.
However you can open the .MDW user group file from withing Access and run the queries that are in it (but you can't open the tables) in read only and get the same kind of data that way.