Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2002
    Location
    Gouda, Netherlands
    Posts
    8

    Unanswered: How to check on multiple users in DB

    Hi,

    Does anybody know how I can 'see' in Access-basic coding if there are other people on our network who are currently using the same database as I am?

  2. #2
    Join Date
    Sep 2002
    Location
    Coventry, Warwickshire, UK
    Posts
    74
    The only way I know is to look at the .ldb file. There used to be a program on the Microsoft site which allowed you list the Users logged on to a database by querying the .ldb file. I don't know whether it still exists.

    In our company we write a record to a log file as people log on to each appplication and then write another as they log off. This includes enough information for us to be able to track them should we need to get everyone out.
    Roger Hampson
    XI - ecs (UK) Ltd

  3. #3
    Join Date
    Oct 2002
    Location
    Gouda, Netherlands
    Posts
    8
    Thx, I allready found the program you ment. I'm trying it today..

    it's called MsLdbusr.dll by the way
    Last edited by Vlietinho; 10-16-02 at 05:44.

  4. #4
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    Has anyone used this dll in access 2000?
    The Microsoft site stated to put ?getusers() in the debug window, any ideas where that is?
    Regards
    Jim


    Originally posted by Vlietinho
    Thx, I allready found the program you ment. I'm trying it today..

    it's called MsLdbusr.dll by the way

  5. #5
    Join Date
    Oct 2002
    Location
    Gouda, Netherlands
    Posts
    8
    Nope. Doesn't work.

    I got it working in access97, but after converting that database to access2000 I get this message :

    error #:-14 -- Can't create LDB filename

  6. #6
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    Ohh well.
    BTW where is the debug window?

    Originally posted by Vlietinho
    Nope. Doesn't work.

    I got it working in access97, but after converting that database to access2000 I get this message :

    error #:-14 -- Can't create LDB filename

  7. #7
    Join Date
    Oct 2002
    Location
    Gouda, Netherlands
    Posts
    8
    I really don't know (i never use the debug option), but in the Word file MsLdbusr.doc which comes with the DLL, there is a piece of sample code what you can C/P into you application.

    And that works fine, just change

    Debug.Print "User "; iLoop; ":"; lpszUserBuffer(iLoop)

    into

    MsgBox ("Error #:" & cUsers & " -- " & psError)

    And you should get a message showing the current users..

Posting Permissions

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