Solved

Access 2010 Deployment

Posted on 2013-01-28
4
171 Views
Last Modified: 2013-01-29
Hello - I'm getting ready to deploy an Access 2010 app, and I'm having a surprisingly hard time finding general information that does not center around deploying as a run time app.

Does someone know of an article that just discusses preventing the users from getting to the Nav Pane and Options?

Thanks
0
Comment
Question by:mlagrange
4 Comments
 
LVL 8

Assisted Solution

by:d0ughb0y
d0ughb0y earned 100 total points
Comment Utility
0
 
LVL 20

Assisted Solution

by:GrahamMandeno
GrahamMandeno earned 100 total points
Comment Utility
Basically, you should split the database into back-end (data) and front-end (everything else).  This allows you to modify the front-end and deploy the new version without the hassle of dealing with the data stored in the same file.  The data tables in the back-end are presented as linked tables in the front-end.  You can do this manually, or use the Database Splitter wizard (Database Tools > Move data > Access Database).

You should also deploy the front-end in ACCDE format (File > Save & Publish > Make ACCDE).  This prevents any end users from making changes to your design or code.

Lastly, you should set options in the front-end (File > Options > Current database) to restrict user activity:
Uncheck "Display Navigation Pane"
Uncheck "Use Access special keys"
Uncheck "Allow Full Menus"
Uncheck "Allow default shortcut menus"

You can create your own custom ribbon, but this is a much more advanced process and should definitely be approached in another question.

Good luck!
Graham Mandeno [Access MVP 1996-2013]
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 300 total points
Comment Utility
0
 

Author Closing Comment

by:mlagrange
Comment Utility
Thanks to all - those were all helpful

It looks like setting the database property "AllowBypassKey" still works in Access 2010; otherwise, is there a newer, better way to keep the users from being able to bypass the startup options and get to the nav pane?
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now