Hi Everybody,

I am connecting to a MDB (Access database) like this:

My_conn = CreateObject("ADODB.Connection")
My_conn.Open ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\mypath\mydatabase.mdb")

I would like to sort a table in this database by a field. How can I do that?
Is there any way that I can sort a table inside a MS Access database using VFP?

Thank you,
Ali