[RESOLVED] Sorting an Access Table using VB6 and ADO Connection

At the risk of being redundant, can anyone help me out on how to sort an Access table using VB6 and ADO connection. I'm hoping there's a one line of code to do it instead of looping through all the records. Thanks in advance!

By sorting the access table, do you actually mean the table itself, or the data being returned to the VB6 program..

Short Answer: you cannot in theory sort an access table and it will stay put.. The records are stored in the order they are created irrespective of how it actually looks.

I presume that you are returning the data via an ADO recordset to the vb program??

If so then you will need to return the data inside the recordset in the sorted order.