Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2008

    Unanswered: tracking users in DB

    can someone tell me how to track users or monitor the activity on my Access Db, lets say by having the network username and machine name for each of the users accessing the db file.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    Theres some code int he codebank for this, contributed by Paul Kohn (PKStormy)
    alternatively google the API calls from Dev Ashish
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Dec 2004
    Madison, WI
    This is the technique I use which healdem is referring to above:

    It works very well and is simple to setup. I can tell which user is currently using the mdb and when they opened it. If they are not using the mdb, I can tell when they last opened the mdb. I can even far exceed MSAccess's maximum recommendation on the # of concurrent users in an mdb (I can have 100's of users using an mdb application.) Plus, there are a lot of other things I can tell/do/is problem/etc.. free when using this technique.
    Last edited by pkstormy; 11-28-08 at 19:57.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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