Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2002
    Houston, TX

    Question 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
    Attached Files Attached Files
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts