Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004

    Unanswered: User Level Permissions

    i have an mdb connected to SQL via linked tables,
    i was wondering if it is possible to create a login form, which, depending on the user level, displays a different switchboard/main form. and if it is possible, how i go about setting it up

    any help would be greatly appreciated

  2. #2
    Join Date
    Sep 2004
    Dallas, TX
    sure, set the login form as start form. let user enter username and password, and check with database.
    then according to the user level, you call different form

  3. #3
    Join Date
    Jul 2004
    The above is correct, but have your user security level check procedure in a public module, and call it from each form change button (Or anything else that loads another form).

    This will save you writing the same code over and over again, so it'll be easier to check through if something goes wrong in the future.

Posting Permissions

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