Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Lebanon
    Posts
    44

    Unanswered: Detect connected users

    Hi,
    I have a microsoft access file, shared by 3 computers, I need to write a code that returns the name of the computers where this application is open. Can you help please
    Last edited by stc834; 07-18-07 at 09:06. Reason: Grammar mistake
    Dani_30

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Check out the Jet UserRoster, I have an example in the code bank.
    Last edited by nckdryr; 07-18-07 at 11:21.
    Me.Geek = True

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    In the DB Code Bank, there's a routine to get the username (loginID) which also has code in it to return the computer name as well as a wealth of other information. Look at the SystemInfo class module to see everything you can return. There's an example in it also on how to return some of the other information. http://www.dbforums.com/showthread.php?t=1605962&page=2

    http://www.dbforums.com/showpost.php...3&postcount=22

    But nckdryr's code may do more on what you're looking for.
    Last edited by pkstormy; 07-20-07 at 02:49.
    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
  •