Returns machine name...but

[dgmorr]

Hey guys,

I downloaded a function that can list what users are logged onto an MDB file by machine name. Is there a way to convert it to show the computer login ID? Here is the snippet of code

   Open sPath For Binary Access Read Shared As iLDBFile
   iLOF = LOF(iLDBFile)
   Do While Not EOF(iLDBFile)
      Get iLDBFile, , rUser
      With rUser
         i = 1
         sMach = ""
         While .bMach(i) <> 0
            sMach = sMach & Chr(.bMach(i))
            i = i + 1
         Wend
         i = 1
         sUser = ""
         While .bUser(i) <> 0
            sUser = sUser & Chr(.bUser(i))
            i = i + 1
         Wend
      End With
      sLogStr = sMach & " -- " & sUser
      If InStr(sLogins, sLogStr) = 0 Then
         sLogins = sLogins & sLogStr & ";"
      End If
      iStart = iStart + 64 'increment to next record offset
   Loop
   Close iLDBFile
   WhosOn = sLogins

 

[Oldsoftboss]

Try searching here for "Whoson" (All one word) I remembered a discussion about this some time ago. My search yielded 8 results which should help.

Dave

 

[dgmorr]

Try searching here for "Whoson" (All one word) I remembered a discussion about this some time ago. My search yielded 8 results which should help.

Dave

This is the snippet of code taken from Whoson. It returns the Machine name, but I'd like to have the login ID called.

 

[Oldsoftboss]

But did you search and read the other posts?

 

[dgmorr]

Yeah, just finished reading all the results. Looks like it's not possible to read the login ID's of other users