Question lock all from user but input form

[DARRENRRR]

have a huge DB tables,search,list,query,...........many users for input...access2007.....I need to lock all but two FORMS so user cant see other tables and lists and not let anyone touch DESIGN, VBA, OR INFO ALREADY INPUTTED..... need to have maybe 6 people have full right to all



Thanks Darren:banghead:

 

[Alansidman]

Here is a menu option that will allow you to establish what forms individuals see.

http://www.mrexcel.com/forum/microsoft-access/248191-tutorial-access-menu-permissions-system.html

To hide the navigation pane; http://office.microsoft.com/en-us/access-help/show-or-hide-the-navigation-pane-HA010235717.aspx

To hide the ribbon: http://www.pcreview.co.uk/forums/show-hide-ribbon-navigation-pane-vba-t3089845.html