Microsoft Access How do I remove the Customize Quick Access toolbar?
I need to remove Customize Quick Access toolbar from my Microsoft Access 2010 database. I do not want unauthorized users to view any of the tables and forms before they log into my secured database. I seemed to have been able to remove the privacy option but that should be included in this application. If XML is involved please provide step by step instruction in this. Thank you for all the help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you talking about the right click, shortcut menus?
If you hide the ribbon, using the technique I described above, then the Customize Quick Access Toolbar popup is not visible. At least not in the 2007 database I'm working with.
If you hide the ribbon, using the technique I described above, then the Customize Quick Access Toolbar popup is not visible. At least not in the 2007 database I'm working with.
ASKER
I think that is the trouble it is Microsoft Access 2010.
sorry, don't have 2010 available to test at the moment.
I strongly recommend that you ALWAYS indicate the version of Access you are using in the tags section of your question.
I strongly recommend that you ALWAYS indicate the version of Access you are using in the tags section of your question.
ASKER
Thanks
Perhaps you can consider using your database in Runtime mode ?
(Essentially changing the name from .accdb to .accdr)
(Essentially changing the name from .accdb to .accdr)
Not sure if that's the direction you're intersted in heading ... if so, ... in runtime mode users are not allowed to access the navigation pane or any of the ribbons.....users can run the application, but can't edit any of the objects.
ASKER
Not sure if the owners would let me do this. Does this mean Microsoft Access would not have to be on the local machine? Would it still be allowed to be on the network?
Runtime has worked well for me though Access has already been installed on the local machines.
With 2010 you can download the Runtime Tools from microsoft for users who don't have the full Access version ... here's the web link:
http://www.microsoft.com/downloads/details.
aspx?FamilyID=57a350cd-525
With 2010 you can download the Runtime Tools from microsoft for users who don't have the full Access version ... here's the web link:
http://www.microsoft.com/downloads/details.
aspx?FamilyID=57a350cd-525
ASKER
accdr is not one of my choices to publish as. Also once the user logs in some of them may have authority to change certain things in the database. It is just before they log in the will be able to open the database and have full access by using the privacy option or the QAT customized quick access toolbar.
If you define a startup form, and run the code to hide the nav pane and ribbon in that forms load event, is the Quick Access Toolbar still visible?
ASKER
Fyed I may be making progress. Now I have to show the "toolbar" that I want after they login successfully. I don't see that awful more command button now. Let me test further.
ASKER
docmd.showtoolbar "ribbon", actoolbarno This did the trick on form open. Thanks.
ASKER