Hi I have a statement that checks if a login name belongs to an Active Directory group. The group is set up exactly the same way as all the other groups, which work fine, but it is not returning a positive when a login is part of that group.

Any ideas why the return is a zero instead of a one when the user is part of the group? I'm stumped.

Thanks!

Okay this was just plain silly. Seems like SQL Enterprise Manager and MS Access don't recognize changes in Active Directory groups unless you reboot your PC.

If you look at the groups in Active Directory the changes are there but for some reason they are not picked up until after a restart. Shutting down Access and SQL Enterprise Manager does not do it, it must be a restart of your computer.

Neither will necessarily recognise changes to an account that was/is logged in when the group membership is changed. You really need the account to log off and back onto the domain when group membership is altered.