@amicron - what you're showing is what I mentioned in my original post - controlling what a certain user can do (open forms, click buttoms, view textboxes, etc.). I have a free utility that does that using a custom system table so it uses record based "access rules" rather than VBA hardcoded rules.
https://forestbyte.com/ms-access-uti...access-levels/
What the OP wants is a totally different thing, the need here is to restrict data to a certain subset (so for example a manager can see only their department data). You mention that your third video is showing how to restrict the data for the current user's own records (probably by storing that in the table with a default from the login form), which is closer to what OP wants but still not quite. Restricting data can only be done by manipulating the form's (or report's) recordsource. With an Access back-end that can only be done by criteria in a query; for SQL Server, MySQL, Oracle and similar you can use views in the back-end to enforce the data based on the login permissions.
Cheers,
User access via Logon screen
Windows 10 
Access 2013 32bit
Originally Posted by Gicu
@amicron - what you're showing is what I mentioned in my original post - controlling what a certain user can do (open forms, click buttoms, view textboxes, etc.). I have a free utility that does that using a custom system table so it uses record based "access rules" rather than VBA hardcoded rules.
Reply With Quote
