recordset.sort

[ling_lh]

friends,
Does ADO 2.0 not support this method?
I use Access mdb and jet oledb 3.5.1,
the compiler warned this method is not supported by the provider.
How to manage this?
Update to new edition?
Thanks!

[Clunietp]

I did this with ADO 2.5 & Jet 3.51 driver...you might just have to use a client side cursor instead of the default server side cursor for this to work:

    Dim rs As ADODB.Recordset
    
    Set rs = New Recordset
    
    With rs
        'must use client cursor
        .CursorLocation = adUseClient
        
        'open rs
        .Open "Select * from Customers", "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=Nwind.mdb", adOpenStatic, adLockReadOnly, adCmdText
        
        'sort it
        .Sort = "CustomerID desc"
        
        'sort successful
        MsgBox .Fields(0)
        
    End With

    'cleanup....