Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    austin
    Posts
    146

    Unanswered: tracking a users time in a db

    When users enter the db an event fires that tracks what time they entered into the db. When they leave / exit a hidden form fires an event when it closes to track the users logout time.

    For some reason this only works about 95% of the time and I cant figure out why its not capturing every logout?

  2. #2
    Join Date
    Sep 2004
    Location
    Virginia, USA
    Posts
    98
    I'd be interested in knowing how you do it. I was looking at doing something like this myself. I'm sorry I can't help you with the fix.

    kc

  3. #3
    Join Date
    Sep 2004
    Posts
    161
    if your users can quit your app with the close button on the access screen, you can't capture this event

  4. #4
    Join Date
    Sep 2004
    Location
    Reston, VA
    Posts
    86
    By "tracking time" do you mean that you update a table with the enter / exit times when it happens (i.e. using an ADO Command object or an Update query), or do you store it in a global variable that is "logged" later?

    I have a database that does the same thing and something I've noticed is that if there's an error and the code breaks, the global variables get cleared. If you log them automatically with a Command object or SQL statement, do have error handlers in every procedure to keep the code from breaking? If your hidden form is causing an error on close (before the logging), and you do have an error handler, you could duplicate the code for updating the logout time in the handler.

    Is only the logout time missing? Is it specific to one user? I've had problems with type library references where I work because not all the users have same versions on their PCs.

    Can you tell us the specifics of how your database closes and how the times are logged? It might easier to see the hangup.

Posting Permissions

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