hi everyone;

in my program I need to sort the recordset according to specific field, however it gives an error like "Run-time error 3251: Current provider does not support the neccessary interfaces for sorting or filtering"


rs_data.sort = "k_baslangic" 'is not working..

btw my connection code is

Set conn = New ADODB.Connection

With conn
.ConnectionString = "Provider = Microsoft.JET.OLEDB.4.0; data source = C:\Documents and Settings\kullaniciadi\Desktop\enson.mdb; persist security info = false"
.Open
End With

Set rs_data = New ADODB.Recordset
rs_data.ActiveConnection = conn
rs_data.Open "SELECT k_araba, k_baslangic, k_bitis FROM kira ORDER BY k_baslangic", conn, adOpenDynamic, adLockOptimistic

rs_data.CacheSize = 500


thanks