Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005
    Posts
    26

    Unanswered: Setting passwords to pages

    I would like to set passwords to certain pages in my Access db. Is this possible to just set permissions to select pages? If so, how?

  2. #2
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628
    you could use a login script when the user opens the database. If you use this method, you can check the identity of the logged in user and if the user has the privilege to open that page (im assuming that you are referring to a form), then it will open. Otherwise it will ask for a password, which you can set for each individual page.

  3. #3
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628
    Otherwise, just create a module using the following:

    [code]
    Option Compare Database
    Option Explicit

    Global Const sPage1Pass$ = "Password"
    Global Const sPage2Pass$ = "Password"

    Then your form that loads a password window (you can build one and then change particualrs via VB) will be next.

    Once you have done that, simply place the following code on the OnLoad event of the form you want to protect:

    Code:
    DoCmd.Close
    DoCmd.OpenForm "PasswordForm"

Posting Permissions

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