Results 1 to 3 of 3

Thread: Login Page

  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: Login Page

    Hi all, I have a database that has Access as the front end and SQL Server 2005 on the back end (2005)
    I need to create a log in form and table for the users, so that when they log into the database we can track when they log in and when they log out and what data they updated. Can anyone help wiht this or direct to where I can get the information on how to create this please??


    Thank you

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Why not just use fOSUserName and avoid the hassle of your users needing to remember/maintain yet one more password? Then I just log when they open/close the main form and any other critical info using a fso to write to a text file. Plus I can set up a user table and use that to grant/restrict access priveleges. Works for me at least.
    Me.Geek = True

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Where are you stuck? Create a user table, a user form, a login dialog and code the screens to use the logged in user....
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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