I would like to password protect a form for different user groups. One group should be able to make changes to the form. The other group should only be able to 'read only'. Hope somebody can help me. Access 2007
Group/User-level Security features are available in Access2003 and earlier versions of Access only.
If this is very important to you then you may save a copy of the database into Access2003 version and try to learn different aspects of the database security features before implementing it on a production database.
When you open an earlier version database in Access2007 the User-level security features are available in Access2007.
You can start creating a Workgroup Information File (besides the default Workgroup Information File: system.mdw) and Join the new Workgroup Information File.
You can Run the Workgroup Administration Program by typing the following Command in the VBA Debug Window (Immediate Window):