Results 1 to 3 of 3
  1. #1
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    313

    Disabling Design View for Tabbed Forms

    I'm trying to secure my database. I have disabled the shift key and special access keys and hidden the Ribbon. Is there a way to keep a User from opening a Tabbed Form, right-clicking, and selecting Design?



    Thanks, Eddie

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    yes - by creating a .accde - the only way.

    At a lower level you can disable menus at various levels in File>Options>current database - but you can't be that selective so users may lose the menus for sorting, filtering etc

  3. #3
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    313
    Okay, I'm going to mark this as solved as I found a way to accomplish my objective, which is to keep users from poking around where they don't belong. So, although I can't keep the operators from right clicking the Form's tab and selecting Design, I can tell when a form is in Design mode from another Form or Module. I have a Form that is opened when the Database opens, it calls the Main Menu form and makes itself invisible. While it is sitting in the Background, its Timer Event triggers every 60 seconds. That Event examines all Open Forms and if any are in Design Mode and if the User isn't a Developer, then the action is logged and the Database closes without a Warning. Hope this helps someone. Eddie

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

Similar Threads

  1. forms in design view
    By themebuddies in forum Reports
    Replies: 5
    Last Post: 12-15-2014, 02:07 PM
  2. Replies: 2
    Last Post: 09-02-2014, 06:21 AM
  3. Tabbed forms not showing In Form View
    By missypooh1969 in forum Forms
    Replies: 8
    Last Post: 08-20-2014, 02:26 PM
  4. Disabling Design View
    By DonnyArt in forum Access
    Replies: 1
    Last Post: 06-29-2010, 08:08 AM
  5. Disabling shift for design view
    By geek in forum Access
    Replies: 1
    Last Post: 12-09-2005, 11:38 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