Accessing active directory from MS Access

[Guest]

Hello,

We have an environment in which the mdb file is split into Front end and
Back end; the back end is deployed into a common server and users access the
backend through the front end by logging in. We want to know a way to find
how many users have logged in the mdb at a given time. Also to find who are
they. How do we do this in MS Access? Can we access the Active directory
information from MS Access?

 

[Michel Walsh]

Have you tried the roster?

--------------------------------------
Public Sub ShowUserRosterMultipleUsers()
' see KB article Q285822

Dim cn As ADODB.Connection
Dim rs As New ADODB.Recordset
Dim i As Long
Dim j As Long
Set cn = CurrentProject.Connection
Set rs = cn.OpenSchema(adSchemaProviderSpecific, _
, "{947bb102-5d43-11d1-bdbf-00c04fb92675}")
Debug.Print rs.Fields(0).Name, "", rs.Fields(1).Name, "",
rs.Fields(2).Name, rs.Fields(3).Name

Do Until rs.EOF
Debug.Print rs.Fields(0), rs.Fields(1), rs.Fields(2), rs.Fields(3)
rs.MoveNext
Loop
End Sub
-------------------------------------------------


That won't word with all versions though.

Otherwise, to access the Active Directory, that would be similar that to do
it from VB6 (but I never did that).




Vanderghast, Access MVP