Using an Access 2003 database. I want to write some VBA code that can see whether the current user belongs to a given security group, like so:
If (CurrentUser is in group Foo) then
Do something
Else If (CurrentUser is in group Bar) Then
Do some other thing
End If
Is it possible to read the group membership info from VBA? Thanks.