I am using Access 2007.
I have a Login Screen which asks for username and password. It allows for individual username/passwords.
What I need to work out is how do I restrict some people's access. What I want is for the Admin person to have full access to change data obviously, but other people (committee members) to be limited to viewing the data or printing out reports.
Advice would be much appreciated.