Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    system logon info (97)

    could someone point me in the direction of using the msAccess login info in your mdb? I previously made my own password form to help determine how to control the flow of my menus, etc. but now that I

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: system logon info (97)

    Currentuser() will tell you who the current user is.

    You should be reading the Access Security FAQ if you are implementing Access workgroup security (if you do it wrong you may think your database is secure when it isn't). It can be found at <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q165/0/09.asp>http://support.microsoft.com/support/kb/ar...s/Q165/0/09.asp</A>. Among many other things, you'll find out how to check whether someone is a member of a particular group, which you may find useful.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: system logon info (97)

    The basic idea is to give the admin account a password, and from that point on you always get a login prompt. But the whole topic is pretty complex. I would suggest you refer to one of the books on Access that talks about the concepts associated with security - there are lots of potential gottchas if you are really trying to secure a database. On the other hand, if you are simply trying to keep track of who is doing what, the online help related to security may be sufficent.
    Wendell

Posting Permissions

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