>>If rsTest.RecordCount > 0 Then 'VB ERROR 3704 HERE
>> MsgBox "Records Returned"
>>End If
>>
>
>What's the error message associted with error code 3704 ?
"Operation is not allowed when the object is closed"
The recordset is not being opened for some reason - which is strange because running the SP with the same params in QA does indeed return records. I'm stumped.
Al Williams
Anola MB, CANADA