Metodę podał "Hercog" (hercog@poczta.onet.pl.)
'Ja to robię tak:
Public Sub UserRoster()
Dim conn As ADODB.Connection
Dim rst As ADODB.Recordset
On Error GoTo Proc_err
Set conn = New ADODB.Connection
With conn
    .Provider = "Microsoft.Jet.OLEDB.4.0"
    .ConnectionString = "data source=c:\NazwaTwojejBazy.mdb"
    .Open
End With
Set rst = conn.OpenSchema(adSchemaProviderSpecific, , _
    "{947bb102-5d43-11d1-bdbf-00c04fb92675}")
Do Until rst.EOF
    Debug.Print rst!COMPUTER_NAME, rst!LOGIN_NAME, rst!CONNECTED
    rst.MoveNext
Loop
rst.Close
Proc_Exit:
    Exit Sub
Proc_err:
    
    MsgBox Err.Description
    Resume Proc_Exit
End Sub