Problems with primary key

[bethm]

I am maintaining a massive Access database. One time I was performing the "Filter by Form" filter for date values in a field, and when I removed the filter, several of the records shifted out of order (i.e. the last three records in the database shifted to be the first three records in the database!). I ended up having to rebuild the whole database, which consisted of 114 records. I suspect this is a problem with the primary key setting; I used an autonumber field as the primary key to give sequential numbers to each record. After the mishap, the autonumber values were preserved in the right order, but the contents of those last three records were shifted to the records of autonumbers 1, 2, 3. Could someone explain to me what probably happened there?

 

[Alcar]

I am experiencing the same problem, only that it's not interfering with the performance. I don't use an auto number thou, for technical reasons.
I have a table that generates the ID and then I assign this ID as the Primary ID of the table2
Table 2 is the one that appeared un-ordered.

Alcar