P
Priya Henry
Hi,
I have a few sensitive applications that I am trying to move across to
Access 2007. I want to re-establish the security and in the process I want
the users not to be able to access a few options in the ribbon (Create
table, create forms, create queries and reports, also not allow them to
import data and not allow them to compact and repair the database and view
the back end window) . I tried to do this with this bit of coding on the
Ribbon XML:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="false">
<tabs>
<tab idMso="TabHomeAccess" visible ="true" />
<tab idMso="TabCreate" visible="false" />
</tabs>
</ribbon>
</customUI>
This hides the tab 'tabcreate'. But this allows the user to be able to add
the same options through Quick Access Toolbar. Is there not a way of
preventing it from the quick access toolbar as well?
If I have 'startfromscratch' = true, there are no options displayed hrough
Quaick access tool bar (no option to add them).
Is there not a way to give a bit of flexibility by removing access to
certain functions in the database?
Am I missing something here...please help.
Thanks,
Priya
I have a few sensitive applications that I am trying to move across to
Access 2007. I want to re-establish the security and in the process I want
the users not to be able to access a few options in the ribbon (Create
table, create forms, create queries and reports, also not allow them to
import data and not allow them to compact and repair the database and view
the back end window) . I tried to do this with this bit of coding on the
Ribbon XML:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="false">
<tabs>
<tab idMso="TabHomeAccess" visible ="true" />
<tab idMso="TabCreate" visible="false" />
</tabs>
</ribbon>
</customUI>
This hides the tab 'tabcreate'. But this allows the user to be able to add
the same options through Quick Access Toolbar. Is there not a way of
preventing it from the quick access toolbar as well?
If I have 'startfromscratch' = true, there are no options displayed hrough
Quaick access tool bar (no option to add them).
Is there not a way to give a bit of flexibility by removing access to
certain functions in the database?
Am I missing something here...please help.
Thanks,
Priya