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