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

    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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!