adOpenDynamic Prerequisites

[Ronald Dodge]

OS: W2K Pro, SP4
App & Ver: AC02, SP2
Programming Language: ADO in VBA
Provider: Microsoft.Jet.OLEDB.4.0
DB Setup: FE (1 on Client Side) / BE (Multiple on Shared Server Side)

Hopefully, I have provided enough general information about what I'm working
with above.

What are the prerequisites for having a recordset with the above specs to be
able to open with a Dynamic Cursor rather than with a Keyset Cursor?

I initially tried the following code, but only got the Keyset CursorType
when I do need the recordset to be able to see not only changes, but also
additions and deletions concurrently:

arsTRN.Open "SELECT * FROM tblCNVTRN", adbMD, adOpenDynamic,
adLockPessimistic

Then I tried the following and still to no avail, it went to the Keyset
CursorType.

arsTRN.CursorType = adOpenDynamic
arsTRN.LockType = adLockPessimistic
arsTRN.Open "SELECT * FROM tblCNVTRN", adbMD

 

[Ronald Dodge]

As I learned, Microsoft.Jet.OLEDB.4.0 provider does not allow for dynamic
cursor type, thus why it's been going to keyset cursor type. I will
therefore have to find some other solution to this issue.