Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Oct 2001
    Location
    Indiana, USA
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Password Security (Access 2000)

    I have a number of forms that look almost identical. These forms are used by various departments to enter approvals. I need to implement some 'low-level' security to a form. I am not concerned by malicious entry as much as I am by errant switchboard choices resulting in accidental entry in wrong form.
    My initial thought is to create a password table and assign each department a password, then create a form that would prompt the user to enter the password if the entered string matches the password field then open the desired form. Does this sound feasible, or is there a better solution that I am overlooking? Any help is greatly apprieciated.
    Mark

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Security (Access 2000)

    Just another thought - this assumes you're using your own switchboard, not the MS Add-in.

    You could have your users select which department they're from when they start the database. Store that value in a table (just like storing preferences).
    Then have the switchboard form choices change depending on which department they've selected. (You would probably want to store department names/numbers along with form names in the separate table.)

    To launch the correct form, you could do something like:<pre> Dim strFormName as String, strDeptName as String
    strDeptName = Dlookup("[DeptName]", "tblPreferences")
    strFormName = Dlookup("[FormName]","DeptFormNames","[DeptName]=" & strDeptName)
    DoCmd.OpenForm strFormName 'etc...</pre>

    HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Password Security (Access 2000)

    Sorry, but if the forms look almost identical, then why do you need different forms? If it's a case of having a particular department see the same form but with an extra button or checkbox or something, why not just hide the extras when the user doesn't have the necessary permissions. Using Access security would allow you to test for the group the user was in and hide or show the controls conditionally.
    Charlotte

Posting Permissions

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