Solved

Access 2010 Deployment

Posted on 2013-01-28
4
176 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
ID: 38828901
0
 
LVL 20

Assisted Solution

by:GrahamMandeno
GrahamMandeno earned 100 total points
ID: 38829430
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
ID: 38829472
0
 

Author Closing Comment

by:mlagrange
ID: 38831107
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

792 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