Hi use the following to return a recordset of users connected to an Access 2010 database. All works fine. My question is: it returns a field called SUSPECT_STATE which I ignore. Can anyone tell me what this field represents and in what conditions it is set?
Many thanks,
Jim
Here's the code:
Dim cn As New adodb.Connection
Dim rs As New adodb.Recordset
Const conDatabase As String = <full database path>
' Open connection to Access backend
cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & conDatabase & ";Persist Security Info=False;"
' Open recordset
Set rs = cn.OpenSchema(adSchemaProviderSpecific, , "{947bb102-5d43-11d1-bdbf-00c04fb92675}")
Many thanks,
Jim
Here's the code:
Dim cn As New adodb.Connection
Dim rs As New adodb.Recordset
Const conDatabase As String = <full database path>
' Open connection to Access backend
cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & conDatabase & ";Persist Security Info=False;"
' Open recordset
Set rs = cn.OpenSchema(adSchemaProviderSpecific, , "{947bb102-5d43-11d1-bdbf-00c04fb92675}")