I have a remote database (MySQL) connection, and would like to load a local recordset asynchronously using the adAsyncFetch modifier. However, when I run it, ADO does not fetch it asynchronously. Am I missing something?
cnAsync is an asynchronous connection
rs.CursorLocation = adUseClient
rs.CursorType = adOpenStatic
rs.LockType = adLockBatchOptimistic
rs.Properties("Initial fetch size") = 1
rs.Properties("Background fetch size") = 100
rs.Open strSQL, cnAsync, , , adAsyncFetch