Results 1 to 8 of 8
  1. #1
    TomD
    Guest

    Table locks and user notification (Access 97)

    Does anyone know how I can determine what users are currently using/accessing the application/tables in a multiuser environment? When I need to perform maintenance on a table, I'd like to be able to notify everyone that's currently using the system to exit the app so I can do my updating. Access does keep an .LDB file and I'm wondering if the user information can be obtained from it and an instant message can be generated to notify them to log out.

  2. #2
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table locks and user notification (Access 97)

    Check this <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=acc&Number=23577&page=& view=&sb=&o=&vc=1#Post23577>post</A>
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Table locks and user notification (Access 97)

    There's also a free download called Jet4Admin that is available from <A target="_blank" HREF=http://www.fmsinc.com/>http://www.fmsinc.com/</A>, which allows you to administer a Jet database. This is a very powerful tool, though, and you add and remove databases from it--they go in to stay. However, it will not only show you who is logged on to the database you're administering, it will allow you to throw them all out so that you can do maintenance.
    Charlotte

  4. #4
    2 Star Lounger
    Join Date
    May 2001
    Location
    Omaha, NE USA, Nebraska, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table locks and user notification (Access 97)

    This looks like a cool utility, went to download and found this.
    Attached Images Attached Images

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Table locks and user notification (Access 97)

    I knew it worked with all versions, but I had forgotten that you needed 2000 to install. Thanks for pointing that out, Steve.
    Charlotte

  6. #6
    Lounger
    Join Date
    Jun 2001
    Location
    Syracuse, NY
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table locks and user notification (Access 97)

    Outside of the services offered by JET 4.0 already mentioned, you can use the functions found in Msldbusr.dll, to read the .LDB file. Notification can occur on the netwrok level or be something that you build into the app. Here's a link to a MSKB article that will give you the info/code that you need:

    <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q186/3/04.ASP>http://support.microsoft.com/support/kb/ar...s/Q186/3/04.ASP</A>

    Jim.

    Edited to add active link--Charlotte

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Table locks and user notification (Access 97)

    Thanks, Jim. I knew that article was out there, but I couldn't find it.
    Charlotte

  8. #8
    TomD
    Guest

    Re: Table locks and user notification (Access 97)

    Thank you all for the responses. I'm going to attack this one using the .DLL to read the locks. Hopefully, I'll be able to write a routine to allow me to notify the users that they need to log out of the app so I can perform maintenance.

    Thanks again

Posting Permissions

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