Good afternoon!
I am building a database at the moment that is based on 2 Forms: Adding a new client, editing an existing client. The main form on opening has two buttons, one for each of these client forms. I want the database to be set up to have 4 levels of User Access:
AUTHORISED USER: To be able to run queries and reports already set up; I am assuming I would need a third button to go to a new form displaying buttons for the various queries and reports.
APPROVED USER: To be able to do as the AUTHORISED USER, but also use the Edit Client form to amend data for existing clients.
SUPER USER: To be able to also add new clients using the New Client form.
SUPER ADMIN: Access to everything, including accessing tables; basically as if there were no security controls at all in place.
Any advice on how to start setting this up would be much appreciated.
Many thanks,
MrBee
I am building a database at the moment that is based on 2 Forms: Adding a new client, editing an existing client. The main form on opening has two buttons, one for each of these client forms. I want the database to be set up to have 4 levels of User Access:
AUTHORISED USER: To be able to run queries and reports already set up; I am assuming I would need a third button to go to a new form displaying buttons for the various queries and reports.
APPROVED USER: To be able to do as the AUTHORISED USER, but also use the Edit Client form to amend data for existing clients.
SUPER USER: To be able to also add new clients using the New Client form.
SUPER ADMIN: Access to everything, including accessing tables; basically as if there were no security controls at all in place.
Any advice on how to start setting this up would be much appreciated.
Many thanks,
MrBee