Index objects specify the order of records accessed from database tables and whether or not duplicate records are accepted, providing efficient access to data. For external databases, Index objects describe the indexes established for external tables. The Indexes collection contains all the stored Index objects for a TableDef object.
Microsoft Jet uses indexes when it joins tables and creates Recordset objects. Indexes determine the order in which table-type Recordset objects return records, but they don’t determine the order in which Microsoft Jet stores records in the base table or the order in which any other type of Recordset object returns records.