Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Is there a way to "lock" the Create group so nobody can use it?

Just wondering...  Is there a way to "lock" the Create group so nobody can use it?

--Steve
0
SteveL13
Asked:
SteveL13
  • 3
  • 2
  • 2
2 Solutions
 
PatHartmanCommented:
What is the "Create Group"?
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Are you referring to the Navigation Pane "Custom Group" option? If so, then no, there's no way to do that.

In a production app, users really shouldn't see the nav pane anyway. You should instead provide a "menu" of some sort (menu form, ribbon, etc) that allows users to navigate as they needed. Allowing the nav pane is just asking for troubles, since the user can get directly to Tables, queries, etc.
0
 
SteveL13Author Commented:
No, I'm talking about the options on the ribbon at the top of the screen.  I know I can "turn off" the "Create" group by right clicking the ribbon and choosing "Customize the Ribbon" and unchecking the "Create" checkbox.  But then any user could do the same thing and check it again.
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
PatHartmanCommented:
If you compile the app to an .accde and then rename it to .accdr, Access will pretend to be the runtime engine and the runtime engine doesn't allow any design changes.  This is merely a trick but it will work for most users.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If you deploy a compiled file (i.e. .accde or .mde) then the user cannot make many changes, although they can add Macros, Tables and Queries. The would not be able to add/modify Forms, Reports, or Modules, however.

You'd also probably want to use a customized ribbon, and then uncheck the "Allow Full Menus" and "Allow Default Shortcut Menus". This would not let the user get to the options menu, so they couldn't change it. However, it also means they must have some way to navigate around your app - like a menu form, or a custom ribbon.

If I do those things and do NOT supply a custom ribbon, I get an interface with the Nav Pane (which you can also disallow in the Options dialog), and File and Home tabs. The file tab allows me to set Privacy options, manage Add-ins, and Exit. I cannot get to the Options menu in that setup.

Here's a great tool for creating custom ribbons: http://www.ribboncreator.de/en/. Note there are versions specific for 2007 and 2010, so if you use this be sure to get the right one.
0
 
SteveL13Author Commented:
I have d/l and installed the ribbon creator for 2010 but when I try to open an Access file I get an error>>>

"There is no table USysRibbons in the selected database"
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Ribbon Creator is a bit tricky to work with at first, but if you read through the tutorials it'll come to you pretty quickly.

It will add the tables, and code modules, and such, but you have to do things in the right order. I don't recall the exact steps, but the website should have everything you need to get started.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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