Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Save database front end

Posted on 2014-03-10
2
Medium Priority
?
475 Views
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?
0
Comment
Question by:cansevin
2 Comments
 
LVL 25

Assisted Solution

by:SStory
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
http://www.microsoft.com/en-us/download/details.aspx?id=24569
0
 
LVL 85

Accepted Solution

by:
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:

http://msdn.microsoft.com/en-us/library/office/cc136539(v=office.12).aspx
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

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 …
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
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.
Suggested Courses

972 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