I am designing a database were I'd like to create a usergroup for managers to edit the database tables etc....and a usergroup for staff who are only allowed to data entry. I will like the managers to have exclusive use of a particular form which I particularly created for their use. Which queries have been designed for their sole purpose to retrieve data. I have created two separate log-in and passwords for both managers and admin staff. Based on their log-ins is it possible when the users are logged onto the database that they each have rights and restrictions to gain or not to gain access to certain forms on the database? Its important that due to the information stored on the database that the admin staff are unable to have the same privileges and gain access to certain data or make edited changes within the database as the senior managers. Based on their unique passwords and usernames can this feature be created? If so, how?
I appreciate the assitance with this interesting challenge.