An Indexes collection contains all the stored CdbIndex objects of a CdbTableDef object (Microsoft Jet workspaces only).
Remarks
When you access a table-type CdbRecordset object, use the object's CdbIndex property to specify the order of records. Set this property to the Name property setting of an existing CdbIndex object in the Indexes collection of the CdbTableDef object underlying the CdbRecordset object.
Note You can use the Append or Delete method on an Indexes collection only if the Updatable property setting of the containing CdbTableDef object is True.
After you create a new CdbIndex object, use the Append method to add it to the CdbTableDef object's Indexes collection.
Important Make sure your data complies with the attributes of your new index. If your index requires unique values, make sure that there are no duplicates in existing data records. If duplicates exist, the Microsoft Jet database engine can't create the index; a trappable error results when you attempt to use the Append method on the new index.