Recordset order is not same as Table order

[jackiev]

We have a VB5 program that has been running for a couple of years. Recently we have encountered an issue that I know
how to fix, but i don't know the cause.

The program pulls a recordset from an Access Database Table
(Select * from Table where Print_Date is Null), then prints
a form from each record, adds a Print_Date & updates the table record. This program has worked fine for years.
The order of the printed records has always been the same as the order in the table UNTIL RECENTLY...
A couple of months ago, the program began printing the
forms in MOSTLY the same order as the table. It starts printing about 2/3 of the way down, goes to the end, then comes back to the beginning & prints the first 2/3. Any ideas what may have caused this quirk?

 

[bjrollet]

I haven't worked with access for some time, but i believe if you change the sort order while viewing the table, that will be the order it remains in. Just use a ORDER BY clause in your app.