Save database front end

Posted on 2014-03-10
Medium Priority
Last Modified: 2014-03-25
Is there a way to save the save a database front end where the user will not be able to get get to any of the formula's, queries, etc? If so, how and is it easy to do?
Question by:cansevin
LVL 25

Assisted Solution

SStory earned 1000 total points
ID: 39918404
There is Tools->Security. There is also a switchboard (Tools-Switchboard) which you can use to start with a default form and the average user can't get to that.  Or there is the Access developer edition
LVL 86

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 total points
ID: 39919226
Access 2007 no longer includes User Level Security, unless you're working in the older .mdb format. 2010 and 2013 are the same way, and I'm not even sure 2013 would open a ULS-secured database.

Developer Editions have not been produced since Access 2003, but your link points to the Developer Extensions. That said, the only thing the Dev Extensions provide is the Package Wizard, Template features, and Source Code features.


If you save your database as a .accde file and deploy that, users cannot get into the Design of your Forms, Reports or VBA code. They can, however, open Tables, Queries and Macros, and in some cases can make and save changes to those.

You can "secure" 2007 to some degree:

Don't show the Nav Pane, and instead include some sort of menu form, as SStory suggests

Don't use built-in ribbons. Create your own and deploy those, and control what the user can get to.

Disable the Shift Key bypass.

Force the users into Runtime mode

This article goes into much more detail:


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.

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

When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Suggested Courses

627 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