[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 628
  • Last Modified:

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.
0
mrdbmagic
Asked:
mrdbmagic
  • 7
  • 4
  • 3
1 Solution
 
Dale FyeCommented:
You can hide the navigation pane with:

DoCmd.SelectObject acTable, , True
docmd.runcommand accmdWindowHide

and the standard ribbon with:

DoCmd.ShowToolbar "Ribbon", acToolbarNo    'Hide it

Actually, the first line of the Hide Navigation Pane stuff above actually selects the navigation pane, which makes it visible.  The second line actually hides it.

And to display the standard ribbon, use:

DoCmd.ShowToolbar "Ribbon", acToolbarYes   'show it
0
 
mrdbmagicAuthor Commented:
I can control the navigation pane and the ribbon but the Cusotmize Quick Access toolbar is still there with the users being able to show anything they want.
0
 
Dale FyeCommented:
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.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
mrdbmagicAuthor Commented:
I think that is the trouble it is Microsoft Access 2010.
0
 
Dale FyeCommented:
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.
0
 
mrdbmagicAuthor Commented:
Thanks
0
 
DoveTailsCommented:
Perhaps you can consider using your database in Runtime mode ?  
(Essentially changing the name from .accdb to .accdr)
0
 
DoveTailsCommented:
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.
0
 
mrdbmagicAuthor Commented:
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?
0
 
DoveTailsCommented:
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-5250-4df6-bfd1-6ced700a6715&displaylang=en
0
 
mrdbmagicAuthor Commented:
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.
0
 
Dale FyeCommented:
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?
0
 
mrdbmagicAuthor Commented:
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.
0
 
mrdbmagicAuthor Commented:
docmd.showtoolbar "ribbon", actoolbarno This did the trick on form open. Thanks.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 7
  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now