Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Access 2010 Deployment

Posted on 2013-01-28
4
Medium Priority
?
180 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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
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.
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.

650 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