Can no longer open a dynamic Recordset (adOpenDynamic)

  • Up until 2 days ago, I could open recordsets using the CursorType = adOpenDynamic. I made a few changes to my class and now I can no longer open it this way. They always open as adOpenStatic even when I specify adOpenDynamic in the open command. I went back thorough the changes and nothing stands out to cause this issue, but clearly something has changed.


    Anyone have any thoughts on where to look.


    Simply using


    rst.Open sqlString, Conn, adOpenDynamic, adLockOptimistic


    EDIT:
    So I can open a dynamic record set using a Select * from myTable sql command. However, if I try and load the same thing using a Stored Procedure, it is static. Not sure why that is the case.