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.
--
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
"Ronald Dodge" <(E-Mail Removed)> wrote in message
news:%23u0%(E-Mail Removed)...
> 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 R. Dodge, Jr.
> Production Statistician
> Master MOUS 2000
>
>
|
Similar Threads
