Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 477
  • Last Modified:

Save database front end

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
cansevin
Asked:
cansevin
2 Solutions
 
SStoryCommented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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