ACC: Data Not Sorted in Index Field Order

MORE INFORMATION

Steps to Reproduce Behavior

1. Start Microsoft Access and open any database.
2. Create a table with three fields. Make one of the fields an AutoNumber field, and make the other two Text fields.
   
   NOTE: In versions 1.x and 2.0, AutoNumber is called Counter.
3. Do not specify a primary key for the table. Define an ascending compound index on the two text fields. For example:
   

         Index Name     Field Name     Sort Order
         ----------------------------------------
         FieldText      Field1          Ascending
                        Field2          Ascending
   						

   
   Set all index properties to No.
4. Save the table, and then enter the following data in the table:
   

         AutoNumber  Field1  Field2
         -----------------------
         1           zzzz    dddd
         2           dddd    yyyy
         3           mmmm    iiii
   						

   
   
5. Close the table, and then open it in Datasheet view. Note that it is sorted as follows:
   

         AutoNumber  Field1  Field2
         -----------------------
         2           dddd    yyyy
         3           mmmm    iiii
         1           zzzz    dddd
   						

   
   
6. Switch to Design view and add the AutoNumber field to the index:
   

         Index Name     Field Name     Sort Order
         ----------------------------------------
         AutoNumber     Autonumber     Ascending
         FieldText      Field1         Ascending
                        Field2         Ascending
   						

   
   Leave all the index properties set to No.
7. Save and close the table, and then open it in Datasheet view. Note that it is sorted as follows:
   

         AutoNumber  Field1  Field2
         -----------------------
         2           dddd    yyyy
         3           mmmm    iiii
         1           zzzz    dddd
   						

   
   Instead of sorting first on the AutoNumber field, and then on Field1 and Field2 as you might expect, the sorting remains unchanged.
8. Set the AutoNumber field's UniqueIndex property to Yes. The table is sorted as:
   

         AutoNumber  Field1  Field2
         -----------------------
         1           zzzz    dddd
         2           dddd    yyyy
         3           mmmm    iiii
   						

   
   Note that the data is sorted on the AutoNumber field.