Access 2007 customisation of Ribbon X and Quick access toolbar

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
 
T

Tom Wickerath

Hi Priya,

If you have custom toolbars and menus in Access 2003 (or lower), you might
want to try this idea for Access 2007:

How do I get my existing legacy menu bars and toolbars to work
in Access 2007? Right now they all show up on the Add-Ins tab.
http://accessjunkie.com/faq_31.aspx

and

Is it possible to not show the Navigation Pane when I open my
database in Access 2007?
http://accessjunkie.com/faq_37.aspx


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
P

Priya Henry

Hi Tom,

Thanks for your response. I have my old applications in Access 2000. I do
not have any cutom made menubars or tool bars. I just disabled some options
using VBA (like the compact and repair, delete option etc). I have also
disabled the shift by-pass key so that the user can never see the back end.
I found that I can achieve this functionaility only by having my custom
ribbon in Access 2007. I have to have the option StartFromScratch =
True...please see code given above.
However, this restricts the user from being able to add some frequently used
options to their QAT. The question is - is there not a compromise of
restricting a few options on the QAT customisation of Access 20007?
Thanks,
Priya
 
T

Tom Wickerath

Hi Priya,
The question is - is there not a compromise of
restricting a few options on the QAT customisation of Access 20007?

Well, by 20007 Microsoft might offer that option! <smile>
All kidding aside, I'm still using Access 2003 for my day-to-day work and
only dabbling in Access 2007 as time permits. So, I don't know the answer to
your question. I did know of Jeff's articles, so I thought I'd point you to
his site (worth bookmarking if you are working in Access 2007 now).


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top