Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2014-02-25
7
Medium Priority
?
293 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 40

Expert Comment

by:PatHartman
ID: 39887876
What is the "Create Group"?
0
 
LVL 85
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 40

Assisted Solution

by:PatHartman
PatHartman earned 1000 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 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 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 85
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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

886 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