I recently upgraded from access97 to access 2003. The process has fortunately been unenventful, but I've noticed one problematic change (anomaly) that I don't understand.
I routinely run a make-table query, to compile data and build a products file for an online store.
Before the upgrade, when I ran this query, any new records in the related tables would show up in the "made-table" located according to numerical order.
Now when I run the query, the newest records are all at the top of the table. I can't figure out why this might be happening and I can't figure out how to make them show up in numerical order again.
This is problematic, because with the items out of order in the products file, they're displaying in the wrong order on the web in the online store.
Anyone know what might be happening here?
Thanks in advance.