Solved

Prevent Access users from being able to see "design" view of form.

Posted on 2014-03-04
6
2,648 Views
Last Modified: 2014-03-04
How can I stop the users from seeing the design view of a form when the right click.

(I am familiar with VBA)
0
Comment
Question by:Patrick O'Dea
  • 2
  • 2
  • 2
6 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 334 total points
ID: 39904750
the best way  is to convert your app to .accde or .mde
0
 

Author Comment

by:Patrick O'Dea
ID: 39904760
Thanks Roy,

Is there any other easy way?

(just wondering!)
0
 
LVL 119

Assisted Solution

by:Rey Obrero
Rey Obrero earned 334 total points
ID: 39904765
you can also use the following setting
Office button > access options > current database

uncheck the followingx
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 75
ID: 39904769
You can also Lock your VBA project ... by using a password.
Quick and simple.
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 166 total points
ID: 39904774
vba lock
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 39904802
Thanks folks,

I am spoilt for choice!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

861 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

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now