• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 182
  • Last Modified:

Access 2010 Deployment

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?

3 Solutions
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]
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
mlagrangeAuthor Commented:
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?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now