Results 1 to 3 of 3
  1. #1
    Skydiver16 is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2016
    Posts
    3

    Password protect a design


    Is there a way to password protect just the design of a database? I want to let anyone enter the data but not be able to change the design criteria.

  2. #2
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    With your database open, click on the Office Button in the upper left corner. Click on the Access options button at the bottom of the window. Click on the Current Database Tab.

    On the Navigation Section, uncheck the Display Navigation Pane.

    On the Ribbon and Toolbar Options, uncheck the Allow Full Menus, uncheck Allow Default Shortcut Menus and uncheck Built-in Toolbars.

    On the Applications Options, in the box for Display Form, put the name of the form that you want to open when Access Launches as this will be the only way you can drive the bus.

    Your users will see no ribbon menus or navigation panes. They will not be able to change any forms, queries or tables or reports unless you make it available using command buttons and other objects.

    As a developer, if you need to access any of the "hidden" objects, you will need to open the database by clicking on the name of the file while holding down the Shift Key. You should not inform your users about this.

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Your users will see no ribbon menus or navigation panes. They will not be able to change any forms, queries or tables or reports unless you make it available using command buttons and other objects.
    Not quite true, they can right click on the form or report and select design view. Plus the method outlined by alan, although a start, can easily be over ridden by any user who has a slightly more than basic knowledge of access - they can just go into file>options and change the settings back. Personally I would supply the front end as a .accde, which will protect forms, reports and code.

    You can just password protect code in a vba module

    The whole subject of protecting db's is a common subject, hardest to protect are tables and queries but there are plenty of threads on the subject on this and other forums. - see some links at the bottom of this thread for example

    You need to be clear about what you want to protect and from whom to determine what level of protection you need to attain.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Password Protect a Macro
    By Pure Salt in forum Security
    Replies: 5
    Last Post: 10-22-2014, 07:32 AM
  2. Password protect a form
    By recon2011 in forum Forms
    Replies: 10
    Last Post: 11-18-2012, 04:36 PM
  3. password protect form
    By nkuebelbeck in forum Forms
    Replies: 2
    Last Post: 01-15-2012, 01:02 PM
  4. readonly password protect
    By mlgehle in forum Security
    Replies: 1
    Last Post: 03-13-2010, 08:59 PM
  5. Password Protect Forms
    By Robert M in forum Programming
    Replies: 3
    Last Post: 01-15-2010, 01:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums