Hi,

Just having problems opening a recordset based on sproc that doesn't open forward-only.

Originally tried Command.Execute but this always returns a recordset in forward-only mode. So i tried...

....
Dim rs As New ADODB.Recordset
...
rs.Open "csptgCA_Options ""CA_SubjectVersionDetails"", 0", db, adOpenDynamic, adLockReadOnly

But it still opens it with cursor type of forward-only!

Does anyone know how to do this?

Thanks

If a provider does not support the requested cursor type, it may return another cursor type. The CursorType property will change to match the actual cursor type in use when the Recordset object is open. To verify specific functionality of the returned cursor, use the Supports method.

Try adOpenStatic instead of dynamic and see if that works.