Option Explicit
Public cn As ADODB.Connection
'
' close db on cmd button pushed
'
Private Sub cmdClose_Click()
cn.Close
Set cn = Nothing
End Sub
'
' open db on cmd button pushed
'
Private Sub cmdOpen_Click()
Set cn = New ADODB.Connection
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & "M:\SVC DEL COORD\open_items97.mdb"
cn.Open
End Sub
'
' find user on cmd button pushed
'
Private Sub Command1_Click()
Dim adxCat As ADOX.Catalog
Dim adxGrp As ADOX.Group
Dim adxUsr As ADOX.User
Dim cnt As Integer
Set adxCat = New ADOX.Catalog
Set adxGrp = New ADOX.Group
cnt = 1
adxCat.ActiveConnection = cn
For Each adxGrp In adxCat.Groups ' <== ERROR MSG HERE <==
lstGroups.AddItem adxGrp.Name
cnt = cnt + 1
Next
Set adxCat = New ADOX.Catalog
Set adxGrp = New ADOX.Group
Set adxUsr = New ADOX.User
For cnt = 0 To lstGroups.ListCount - 1
lstGroups.Selected(cnt) = False
Next cnt
Set adxCat = New ADOX.Catalog
Set adxUsr = New ADOX.User
Set adxGrp = New ADOX.Group
adxCat.ActiveConnection = cn
For Each adxUsr In adxCat.Users
' If adxUsr.Name = cmbLogonId Then
For Each adxGrp In adxUsr.Groups
For cnt = 0 To lstGroups.ListCount - 1
If adxGrp.Name = lstGroups.List(cnt) Then
lstGroups.Selected(cnt) = True
End If
Next cnt
Next
' End If
Next
Set adxGrp = Nothing
Set adxUsr = Nothing
Set adxCat = Nothing
End Sub