It's not clear to me what you're asking about. Is it that the order of the
records in your table isn't what you expect? Never assume anything about the
order of records in tables: tables are unorganized "sacks of data", where
the data's put wherever it fits. If the sequence of records is important,
you must ensure there are appropriate fields to sort on, and use a query
with an ORDER BY clause.

Well, I'd suggest that you abandon the idea that records in a table *have* any
defined order. They don't. A table is an unordered "heap" of records; it will
be presented in whatever order the JET database engine finds convenient. Often
this will be in primary key order, but there's no guarantee.

If you want to see records in a particular order, you must - no option! - use
a Query sorting the fields in that order. Such a query will be updateable and
should not interfere with your use of the database.

            John W. Vinson [MVP]

There was a bug at one point in time with a version of Jet which didn't handle
indexes with descending properly.

I'd double check that you have Jet 3.51 SP3 3.51.3328.0 installed.  Although this may
have been a problem in Jet 4.0.  Look in the \Windows\System or similar directory for
the above files.  Then right click on the file >> Properties >> Version.

There is a similar problem here but I don't think this was it.
BUG: You may notice an incorrect sorted order when you sort the negative decimal
values in descending order in Access
http://support.microsoft.com/kb/837148/en-us

Tony

Just note that the classic cause of this particular
problem is that the century digits are hidden
(short date format) and incorrect.

(david)