Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Location
    Aberdeen, Scotland, UK
    Posts
    168

    Unanswered: Who has a database open?

    In Access 97 there was an unsupported dll from Ms called "MSLDBUSR.DLL" that allowed interrogation of the Access .LDB file to ascertain who was logged into a database.

    This doesn't seem to work with 2002 (unless I'm just being dense which is very likely). Does anyone know:

    a) If I'm just being an idiot.
    b) There is a new .DLL that will do it.
    c) Any other ways.

    Thanks in Advance

    J.

  2. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    Try this instead of unsupported dll's

    198755 ACC2000: Checking Who Logged into Database with Jet UserRoster

    http://support.microsoft.com/default...b;en-us;285822

    this is the solution

  3. #3
    Join Date
    Jan 2003
    Location
    Aberdeen, Scotland, UK
    Posts
    168
    It's giving me user-defined data type errors but I think it's my references.

    Thanks for the quick response.

    John

  4. #4
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    it is the references

    no prob

Posting Permissions

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