General information
Category:
Database DAO/RDO/ODBC/ADO
Title:
Sorting a Recordset
I am using.......
cnSMDR1.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= C:\Tracit\SMDR1.mdb"
and
rsCompany.Open "Company", cnSMDR1, adOpenKeyset, adLockOptimistic
to open my recordset. When I use the command rsCompany.Sort = "CompanyName", it returns the error, "Current provider does not support the nessecary interfaces for sorting or filtering". Any suggestions on how I can sort this recordset before I use it?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only