This is a Cross-Post from the Databases Q&A forum:<BR><BR>I am appending a parameter to a command object, then using that command object to execute a stored procedure. The parameter is used inside the stored procedure as an input parameter. The results of the stored procedure are then stored in a recordset. After that, I am filtering the recordset twice. The first filter (line #1) works ok, the second filter (line #2) fails... <BR><BR>Line #1) objRS.Filter = "field_name = &#039;some_value&#039;" <BR>Line #2) objRS.Filter = adFilterNone <BR><BR>The failure generates the following error upon executing line #2. <BR><BR>*****Microsoft OLE DB Provider for SQL Server error &#039;80040e18&#039; <BR>Rowset position cannot be restarted.*****<BR><BR>Any ideas on why this is occurring? <BR><BR>