473,387 Members | 1,530 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

How to restrict design and layout views

I have a database in which I would like to restrict some users from accessing the design and layout views of all objects in the navigation pane. However, I would also like administrative users to be able to access these views.

Can anyone help
Oct 29 '12 #1
4 10579
Seth Schrock
2,965 Expert 2GB
In Access 2010, if you go into design view and view the form's properties, Format tab, there is a property called Allow Layout View. Change this to No.

I don't believe that there is a way to disable design view for some and not for others. You can create a RunTime file that disables all editing capabilities, but a simple change of the file extension (from .accdr to .accdb) re-enables this.
Oct 29 '12 #2
TheSmileyCoder
2,322 Expert Mod 2GB
For what we can call a low level of security on a non-split app, you go into options and disable the navigation pane and disable the "Access special keys". This among others disables the F11 key to open the navigation pane. Also disallow Full menus, and default shortcut menus.

This basicly disables all of the design functionality of access UNLESS you hold down shift when you startup the db. This should help prevent unknowing users from accidentally modifying stuff.

If you want more security then that, you need to split the db, and distribute a compiled client, but thats significantly more difficult.
Oct 29 '12 #3
NeoPa
32,556 Expert Mod 16PB
That used to be supported by older versions by using a System file. It caused so many issues though (It took a good deal of care and understanding to avoid mucking things up if the defaults weren't used) that they removed the facility.
Oct 30 '12 #4
Thanks everyone for your help
Oct 30 '12 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

47
by: Neal | last post by:
Patrick Griffiths weighs in on the CSS vs table layout debate in his blog entry "Tables my ass" - http://www.htmldog.com/ptg/archives/000049.php . A quite good article.
25
by: John Morgan | last post by:
Though I have designed and implemented a number of large reasonably well received web sites I do not consider myself a graphics designer I am now for the first time going to work with a ...
0
by: penguin732901 | last post by:
Has anyone successfully used a page layout or graphics program to be run from Access? That is, if a database has information about customers, and you would like to design (layout & typeset)...
8
by: IT | last post by:
I looked thru the 7+ chapters and Microsoft seems vague. Bascially telling you to design it so it makes sense. Duh. Say I have an app that handles processes for the claims, finance and...
7
by: JJ | last post by:
Having done most of the background sql coding I'm now ready to start designing my asp.net web pages. A basic question though - is there a way of having 'common' elements on pages (e.g. a...
5
by: A_M_IS | last post by:
Dear valuable experts, I truly hope than You can suggest for me Your ideas how to resolve design. I developing relative small Access VB tool, for single user use only. Access version 2003, but db...
7
by: toton | last post by:
Hi, I have a STL vector of of characters and the character class has a Boost array of points. The things are vector<Characterchars; and class Character{ private: array<Point,Npoints; }; Now...
3
by: ljungers | last post by:
Hello to all you HTML experts. Have been searching the net for some type of open source or low cost form IDE designer. Have used Dream Weaver a few times and experimented with a couple of share ware...
3
by: Vai2000 | last post by:
Hi All, I am coming from old school web-design so prefer table layout. I see people using div just everywhere...? Why aren't they using tables? which is better? esp. when u have objects custom...
0
by: news | last post by:
Did some Google and newsgroup searching, but can't find any stencil packs for Kivio that are Web design themed. Oh, I can use some of the generic squares and shapes from the stock stencil...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.