Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2013

    Unanswered: User group passwords

    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

  2. #2
    Join Date
    Jan 2009
    Kerala, India
    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):

    DoCmd.RunCommand acCmdWorkgroupAdministrator
    Check the following Links for details:

    Running Workgroup Admin in Access2007
    Microsoft Access Security (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts