Solved

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

Posted on 2014-02-25
7
289 Views
Last Modified: 2014-02-26
Just wondering...  Is there a way to "lock" the Create group so nobody can use it?

--Steve
0
Comment
Question by:SteveL13
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 37

Expert Comment

by:PatHartman
ID: 39887876
What is the "Create Group"?
0
 
LVL 84
ID: 39888393
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
 

Author Comment

by:SteveL13
ID: 39888678
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 37

Assisted Solution

by:PatHartman
PatHartman earned 250 total points
ID: 39889260
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
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 39889296
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
 

Author Comment

by:SteveL13
ID: 39889990
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
 
LVL 84
ID: 39890214
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question