Create a query from within Access that attaches to my SQL Server and retrieves the recordset. I'd likely use the same technique I applied in this thread. <BR>2.

If 2K or above, ADO is the default data access library; and ADO Recordsets do sort properly.<BR><BR>Having said that, I would still prefer to use an ORDER BY clause in the SELECT statement.

The Recordset object is an essential component in Access development, but it often trips up even experienced developers. Susan Harkins explains 12 common Recordset pitfalls you can anticipate and ...