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!