Customize front-end for each user

[Philip]

I have a split database with HR, Inventory, Payroll and other features. How
can I set each front-end to allow access to only the elements needed by each
department.

 

[SF]

Hi Jeff Boyce,

I am very interested in your approach. How do you define your "Class" for
each group of people based on login info?

SF

 

[Jeff Boyce]

Philip

One way to approach this is to create a single Front-End, but with multiple
"paths" through. One application I created used the same back-end tables
and the same generic screens, reports and functions, but required a logon
that resulted in each different "class" of user to have a
"customized-to-their-program" appearance.

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Anthos]

A method that I used was creating "Security Groups" inside access.
When a user processed the login form, it would check what Security
Groups they where a member of and from that hide / show functions as
required.

This meant that a user could be a member of both payroll, HR etc and
have the applicable form appear.

 

[Jeff Boyce]

I created a "login" screen that required the user to select a class (ADMIN,
USER, DEVELOPER) and to provide the appropriate password. Then I created
multiple selections (PROGRAM A, PROGRAM B, ...).

The "class" got them in, the PROGRAM determined the "look & feel" of their
"customized" application.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Philip]

Thank you.
This sounds like the "log-in" screen that appears on the 2007 Northwind
sample. I understand how the form works, but I could not find the macro(?)
that starts this form when the database loads.

 

[Anthos]

It could also be the default form that is loaded when the database
starts.
- Access Options - This Database - Display Form

Otherwise it would be an Autoexec macro file that would run it.

 

[Philip]

Thanks.