There seems to be a plethora of ways to create ADo recordsets. I'm trying to find out the most efficient method for a basic read to load info into a combo box etc.
My understanding is that this is to create a firehose cursor forwardonly,serverside and cachesize=1.
Is this correct?. Also I open one connection gConn at the beginning of my project in which the cursor is set client side.
Can I use this same connection to create a firehose cursor by setting the recordset cursor to serverside?
e.g With ss
.CursorLocation = adUseServer
.CursorType = adOpenForwardOnly
.LockType = adLockReadOnly
.CacheSize = 1
.Open strSQL, gConn
Get the impression I'm not sure what I'm doing (no points for this part)?
Any additional info on this issue welcome!