ADODB Cursors

shamas21

Registered User.
Local time
Today, 00:56
Joined
May 27, 2008
Messages
162
Hi All

Can someone explain Cursor Types in ADODB VBA? Ive looked at at articles and its something along the line of moving through returns rows of data sequentially.

But the following types of Cursors seems to do the same thing for me i.e. I can still MoveNext, MovePrevious, MoveFirst etc...

So im not sure what the purpose of the following are

Code:
rs.Open "tbl_test", CurrentProject.Connection, adOpenDynamic, adLockReadOnly

'adOpenForwardOnly
'adOpenDynamic
'adOpenKeyset
'adOpenStatic

Thanks
 
Ok - I figured it out. In Access this rule doesnt seem to apply so whether you use adOpenForwardOnly or adOpenStatic you can still move forward and back etc... however when I try it using ADODB to connect to SQL Server then it these rules do apply i.e. I cant use MovePrevious is a adOpenForwardOnly.
 

Users who are viewing this thread

Back
Top Bottom