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.

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.

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 ...