(MS Access+SQL Server) How can I restrict access to form by Domain User Group?

[phinix]

Guys I need help - I have SQL server and MS Access database.
There is a form that I want to make accessible only for one group of people.
I don't know how can I make it work - what I want to do is I want it to check what Domain User Group the user belongs to and then open this form (only if the user beloongs to that group that can have access to it).

How can I do it? Any help would be very much appreciated!

 

[Dolph]

IIRC it's not possible, or perhaps more accurately not possible in any way that's simple, to get access to read domain user groups. Access has it's own security setup with groups, and while you can easily capture windows login and domain details, domain user groups are a real nightmare to achieve.