Unanswered: VBA ADO SQL2K question
I have some code that works just fine EXCEPT when I call a certain stored procedure. When I call the "special" sp, the first time I reference the result set I get an error "Operation is not allowed when the object is closed." source "ADODB.Recordset". I can substitute sp_who3 for the "special" sp and everything works!
I am stumped as to what the problem could be or what to do next. Any help would be appreciated!
The sub is attached
(Knowledge is power! Get some!)