ADO Index Property
The Index property sets or returns a string value that indicates the
name of the current index for a Recordset object. The index must have
been created as an index on the table or as an ADOX Index object. This
property can be set on an open or closed Recordset.
Note: This property is used together with the Seek method to
create an indexed display of records and to use the Seek method to
search these indexed records, but few providers supports this property
and method. Use the Supports method to determine whether the provider
supports seek and indexes.
Syntax
Examples
If objRecordset.Supports(adIndex) Then
objRecordset.Index = "AddressIndex"
End If
|
|