I need to set permissions to my MS Access 2013 database. I only need 1 login page which will take credentials from 3 accounts
The database will be shared to a Shared Folder on the network or placed on SharePoint. You may also advise on this one.
1. the data capturer should not be able to previous records, all they do is capture the data and can update in case of a wrong entry using the same screen.
2. the data viewer can view all captured data but cannot modify any entries
3. the data administrator must be able to add and / or delete users, columns etc but must not interact with the actual data captured.
please assist.
i have attached the DB here so that you may help me. i am quite new to access and have a rusty memory of relational databases so please excuse the rudeness of my design.
The database will be shared to a Shared Folder on the network or placed on SharePoint. You may also advise on this one.
1. the data capturer should not be able to previous records, all they do is capture the data and can update in case of a wrong entry using the same screen.
2. the data viewer can view all captured data but cannot modify any entries
3. the data administrator must be able to add and / or delete users, columns etc but must not interact with the actual data captured.
please assist.
i have attached the DB here so that you may help me. i am quite new to access and have a rusty memory of relational databases so please excuse the rudeness of my design.