hello,
when a user opening access, it should be able to access the form according to the roles
The table name is tblUser and the users are General User, HR, and Admin.
Currently, In the table I have the roles assigned number with GeneralUser (read-write) = 1, HR(Read-only) = 2, Admin(Full access) = 3.
table structure: Name, ID, Roles ID, Roles Desc
How to do that?
For e.g user Amyra Full access to view, read-write in the form
JohnSmith read-only
when a user opening access, it should be able to access the form according to the roles
The table name is tblUser and the users are General User, HR, and Admin.
Currently, In the table I have the roles assigned number with GeneralUser (read-write) = 1, HR(Read-only) = 2, Admin(Full access) = 3.
table structure: Name, ID, Roles ID, Roles Desc
How to do that?
For e.g user Amyra Full access to view, read-write in the form
JohnSmith read-only