Disable design view for most users

Posted on 2008-10-10
Medium Priority
Last Modified: 2013-11-27
I have code that runs as soon as my db is started up.  Is it possible to disable design view for most users?  

I want run:

if ENVIRON("USERNAME")  = "JOe K." then
      <enable design view>
      <disable design view>
end if

JOe K.
Question by:ClaudeWalker
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 44

Assisted Solution

GRayL earned 800 total points
ID: 22689854
I think for this you are going to have to go the route of WorkGroups and Users - providing each user with a logon that loads the appropriate workgroup file which defines his/her privileges.  Google something like - microsoft access workgroup security - for a lot of good info on this subject.  So much has already been written and is readily available - no point in re-inventing the wheel.

Author Comment

ID: 22690180

I googled it and it looks intriguing.

Is it possible to bypass the logon of the workgroup security and use ENVIRON("USER NAME") to act as the logon?

LVL 44

Expert Comment

ID: 22690484
Environ("User Name") does not exist until after the mdb has been opened.  When it comes to security, I believe it's one thing to talk the talk, but quite another to walk the talk.  It seems the first questions are always those of "What if...?" or "Is it possible to bypass...?"  ;-)
Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

LVL 61

Accepted Solution

mbizup earned 1200 total points
ID: 22691134
Not as complete as workgroup security...

A possibility is to have a "Design Access" button that enables/disables the shift-key bypass option or leads to a menu where the user can choose to enable the shift-key bypass.  You can also disable the right click menus that allow a user to go from form view to design view.

You can use code like you initially posted (using the windows login) to hide or show that command button.

if ENVIRON("USERNAME")  = "JOe K." then
      YourButton.Visible = true
     YourButton.Visible = false
end if

Once the user opts to enable shift-key bypass, they will have to restart the database for that effect to take place

The code to enable/disable shift-key bypass can be found here:


Author Comment

ID: 22691528
Disabling the right click should work.  

I just don't want my boss trying to format my forms after they are done.  It will end up screwing up a database that it is linked to.
LVL 44

Expert Comment

ID: 22691812
So you have a boss who thinks he/she knows more about Forms than you do?  How does a well-designed form screw up a database?  ;-)  Good Luck!

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

752 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