Results 1 to 6 of 6
  1. #1
    Join Date
    May 2004

    Unhappy Unanswered: Form Security Question

    I have an Access Form, that has two fields:

    - User

    - Password

    That seems to work ok.

    Now after the user enters the correct username and password, the form closes an opens another form, and it΄s in this new form i wish to set different type of users.

    Now my big question is, how can i set user access levels to the different users, so that one type of users have free access to all fields and other users just have read only.

    In my personnal table i have a field named "Level" that is used to define the user access level - like this:

    - 1 (Administrator)

    - 2 (Read Only)

    Can this be done?

    thank you!

  2. #2
    Join Date
    Nov 2003
    Sussex, England

    Smile Form Security

    Not sure if this is the best way, but global variables might be one way to go. Pick up the security level on the first form, then assign a value to the global variable, e.g. gDataEdit. Then on the load event of each form something on the lines of :

    If gDataEdit = false then me.allowEdits=false

    That's a bit of a simplification, but it covers the general idea. There may be much better ways of doing it though.

  3. #3
    Join Date
    Mar 2004
    Nashville, TN
    I would stick with the already created .mdw system. I have a previous thread that I will see if I can dig up that will go step by step on how to setup users and access security.

    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting by Patriot Designs

  4. #4
    Join Date
    May 2004
    I agree with the global variable. make it a boolean set from the login/password form. Then on each additional form use something like.

    if not authorized then
    end if

    You can put all kinds of restrictive codes there


  5. #5
    Join Date
    May 2004
    how can i do that?

    Need help with the code!

  6. #6
    Join Date
    Jan 2004
    Islamabad, Pakistan
    David I think I've replied to your other thread already...

    see if that helps or else inform and we'll try to further help you out. It is not a big problem...


Posting Permissions

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