Which group is the user part of?

[incog]

Hi, is there a function in ms access vbscript that returns the group the current user is part of. In my access database I need to alter some stuff if the user has admin priviliges. Thanks beforehand.

 

[ghudson]

CurrentUser() will tell you who the user is based on their workgroup. You should know which users have admin privileges. If your db is properly secured then nobody should have admin privileges but the programmer.

 

[Adeptus]

For ix = 0 to Users(CurrentUser()).Groups.Count - 1
    MsgBox Users(CurrentUser()).Groups(ix).Name
Next

 

[ghudson]

I searched around [yeah google really does work] and found a lot of sites with simular information but this one had it all in one place. Check out section 22 "How can I obtain group and user membership information programmatically?" on the below link...
Frequently Asked Questions About Microsoft Access Security for Microsoft Access versions 2.0 through 2000
There is a lot of good stuff on that page.