Currently:
I have an access front end and back end.
The program has a login screen. The program's logic determines what table field information each user is allowed to see.
Can access security be setup to not allow the users to open the tables by directly opening the back end (regardless of what security level the program's logic allows)?
Can access security be setup to not allow the users to open the tables by looking at the linked tables in the front end (regardless of what security level the program's logic allows)?
ex: One table holds a person's social insurance number, name, and address. Some people are allowed to see their SIN, some can see their address, some can see both, and some can see neither (all determined via program logic). I'd like to prevent people from going into the tables directly to see this information.
I have an access front end and back end.
The program has a login screen. The program's logic determines what table field information each user is allowed to see.
Can access security be setup to not allow the users to open the tables by directly opening the back end (regardless of what security level the program's logic allows)?
Can access security be setup to not allow the users to open the tables by looking at the linked tables in the front end (regardless of what security level the program's logic allows)?
ex: One table holds a person's social insurance number, name, and address. Some people are allowed to see their SIN, some can see their address, some can see both, and some can see neither (all determined via program logic). I'd like to prevent people from going into the tables directly to see this information.