Results 1 to 5 of 5
  1. #1
    BRASILO is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Aug 2017
    Posts
    77

    Question password protect Design view


    I'm trying to Password protect my design view from being accessed. Or password protect the navigation panel from being opened. Is this possible? I know that I can set up a password to protect VBA and one to open the DB. However, when the system is split or distributed, there are several ways personnel can access the design and data of the DB. Please provide any insight as to how I can protect this. I'm using Access 2016.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,850

  3. #3
    BRASILO is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Aug 2017
    Posts
    77
    Quote Originally Posted by orange View Post
    Thank you. I did come across these examples. I was hoping for something more advanced. I've noticed a few people know this trick and have accessed the design controls. I thought that there was a way to create a module or some vba snip to add to each form/report to prevent design view access.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,850

  5. #5
    BRASILO is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Aug 2017
    Posts
    77
    Quote Originally Posted by orange View Post
    Here are a few youtubes by Steve Bishop that may get your more info:

    https://www.youtube.com/watch?v=i1n7H686bWI securing
    https://www.youtube.com/watch?v=zoOlakWXG3c encrypting
    https://www.youtube.com/watch?v=DxRpo496w_c managing user access
    Thank you.

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

Similar Threads

  1. Password protect a design
    By Skydiver16 in forum Database Design
    Replies: 2
    Last Post: 08-06-2016, 04:08 AM
  2. Locking Design View With Password
    By kazaccess in forum Security
    Replies: 1
    Last Post: 08-17-2014, 10:08 PM
  3. password protect form
    By nkuebelbeck in forum Forms
    Replies: 2
    Last Post: 01-15-2012, 01:02 PM
  4. Password Protect Forms
    By jlclark4 in forum Security
    Replies: 3
    Last Post: 01-25-2011, 04:26 PM
  5. readonly password protect
    By mlgehle in forum Security
    Replies: 1
    Last Post: 03-13-2010, 08:59 PM

Tags for this Thread

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