I think that when you use an Access FE with a SQL Server BE, then Access will use 'pass-through' queries to get the data. The entire query text is executed by SQL Server, so any ORDER BY clause is run at the SQL Server BE, not by the Access FE.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara