1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
| Dim i As Integer
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & CurrentDb.Name & ";Persist Security Info=False;"
' Open recordset
Set rs = cn.OpenSchema(adSchemaProviderSpecific, , "{947bb102-5d43-11d1-bdbf-00c04fb92675}")
'Output the field list
Debug.Print rs.Fields(0).Name, "|", rs.Fields(1).Name, "|", rs.Fields(2).Name, "|", rs.Fields(3).Name
'Loop through users recordset of users in database.
For i = Me.Userlist.ListCount - 1 To 0 Step -1
Me.Userlist.RemoveItem 0
Next
i = 0
While Not rs.EOF
Me.Userlist.AddItem Trim(rs.Fields(0)) & ";" & Trim(rs.Fields(1)) & ";" & Trim(rs.Fields(2)), i
'Debug.Print Trim(rs.Fields(0)), "|", Trim(rs.Fields(1)), "|", Trim(rs.Fields(2)), "|", Trim(rs.Fields(3))
rs.MoveNext
i = i + 1
Wend
' Close
If rs.State <> adStateClosed Then rs.Close
Set rs = Nothing
Set cn = Nothing |
Partager