i have to forms one for input and one to look and find data, i do not want just anyone to be able to input data , is it possible to set a password to restrict input from other users? if so how do you go about it?
Novice
Windows 7 
Access 2007
form security
i have to forms one for input and one to look and find data, i do not want just anyone to be able to input data , is it possible to set a password to restrict input from other users? if so how do you go about it?
Indifferent
Windows 7 32bit Access 2007
I like to use a menu that allows permissions based upon the level the developer sets. Users can only open forms that they see in the menu. Look here at this tutorial on how to set this up. Additionally, you will want to hide the navigation and lock down the ribbon so that they cannot get to the forms in any manner. Further to this, depending on the level of permission you will want to set the view form to edit disabled for those who do not have editing rights. This would be done on the on-load event for the form.
http://www.mrexcel.com/forum/showthread.php?t=248191
Alan
Form security
Posting Permissions
Reply With Quote