Database and Table security (1 Viewer)

Boi

New member
Local time
Today, 12:38
Joined
Nov 8, 2018
Messages
4
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.
 

isladogs

MVP / VIP
Local time
Today, 10:38
Joined
Jan 14, 2017
Messages
18,186
Can't help with Sharepoint as I've hardly ever used it.

However I did upload a updated version of a password login utility yesterday.
It may provide a lot of the functionality you need. See https://www.access-programmers.co.uk/forums/showpost.php?p=1598987&postcount=4

If its not what you want, there are many other examples available both in this forum and elsewhere online. Do a site/Google search
 
Last edited:

Boi

New member
Local time
Today, 12:38
Joined
Nov 8, 2018
Messages
4
Thanks a bunch, i will be trying this today.
 

Users who are viewing this thread

Top Bottom