Access Database Sorting

How to disable access database pimary key default sorting option?

Use the Order By statement in your SQL statement. Then you can select the order.

select * from table order by fieldname1, fieldname2