User Roles

[tylerg11]

I have a split database - back end SQL Server and the front end is Microsoft Access 2007. I would like to somehow group the users into different roles that I create (specific groupings custom to this project...for example, Payroll, Training, etc.) I would then use these groups to set the criteria as to what object and controls the user sees based on their group. I know this is a big piece, but just wondering if anyone has any ideas or suggestions. Thanks!

[pbaldy]

One way using Active Directory created by my buddy Tom:

http://www.accesssecurityblog.com/po...Directory.aspx

[tylerg11]

One way using Active Directory created by my buddy Tom:

http://www.accesssecurityblog.com/po...Directory.aspx

Thanks! That seems like a better way to go since you are using already existing users in Active Directory. Great idea!

[pbaldy]

No problem! I haven't implemented that in a production db (haven't needed it), but I tested it while he was working on it and it worked well for me.

[tylerg11]

One more question....

Do I have to copy the three modules from the sample project from that link in order to begin using the functions mentioned?

[pbaldy]

Yes, as noted in the link:

To start using the sample code in the attached project, copy these modules to your application: modAPI, modSecurity, and modUtilities. Also set a reference (code window > Tools > References) to "Active DS Type Library" (activeds.tlb). Choose Debug > Compile to make sure the code compiles.