?
Solved

Access 2010 Deployment

Posted on 2013-01-28
4
Medium Priority
?
179 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
[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
4 Comments
 
LVL 8

Assisted Solution

by:d0ughb0y
d0ughb0y earned 400 total points
ID: 38828901
0
 
LVL 20

Assisted Solution

by:GrahamMandeno
GrahamMandeno earned 400 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 85

Accepted Solution

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
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 …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

801 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