I am doing an internship at an insurance Company and I have been tasked to create an employee/facility management database with Microsoft Access 2016.
Although I am still in an early phase of development (eliciting information/requirements),
I have been asked whether it is possible to display a different ribbon based on the login provided.
I am using RibbonCreator and I understand that it is possible to have several ribbons in an Office document.
Is there a way with VBA to change the ribbon based on the login data provided (there are only four logins)?
It looks like that the data is stored in a table called USysRibbons with the following structure:
I understand that it is possible to change the Ribbon inside Access, but it requires a restart of the application.
Would the loading of a different Ribbon with VBA require the same procedure?
Another idea which I have in my mind is that only one customised ribbon with several tabs is shown.
I would then hide or show these tabs based on the login provided.
Is this an easier approach?
Thanks in advance for your feedback which I can put inside the functional requirements.