Solved

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

Posted on 2014-02-25
7
288 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
  • 3
  • 2
  • 2
7 Comments
 
LVL 36

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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 36

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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

820 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