Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: Provider does not support necessary interfaces for sorting or filtering


Message #1 by "Jim Recktenwald" <rmplmn@h...> on Wed, 26 Feb 2003 18:16:06
I can filter fine but receive an error trying to sort.

*****Error******
ADODB.Recordset (0x800A0CB3)
Current provider does not support the necessary interfaces for sorting or 
filtering.
*****Error******


*****Code Start******

data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _ 
	Server.MapPath("rebate.mdb")

Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "rebate", data_source
rs.Filter = "rebate_eligible = True"
rs.Sort = "mem_num"

*****Code End******

  Return to Index