The usual setup is an SQL/MySQL backend with an Access front end.
But if you want to control what users can see and do it will need to be controlled in the front end with VBA/Queries based on a log in.