469,125 Members | 1,737 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,125 developers. It's quick & easy.

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 9985
Seth Schrock
2,957 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
2,321 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
32,161 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

Post your reply

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

Similar topics

47 posts views Thread by Neal | last post: by
25 posts views Thread by John Morgan | last post: by
7 posts views Thread by JJ | last post: by
5 posts views Thread by A_M_IS | last post: by
3 posts views Thread by ljungers | last post: by
3 posts views Thread by Vai2000 | last post: by
reply views Thread by news | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.