Home > IT Answers > Development > VB Asynchronous Recordset
Carbon
0 pts.
 VB Asynchronous Recordset
VBA
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

Software/Hardware used:
ASKED: June 20, 2004  2:22 AM
UPDATED: June 20, 2004  2:11 PM
RELATED QUESTIONS
Answer Wiki:
Check out this article for a detailed code sample http://www.host-web.fr/iishelp/adc/docs/adcdg02_1.htm
Last Wiki Answer Submitted:  June 20, 2004  2:11 pm  by  Mcp111   0 pts.
All Answer Wiki Contributors:  Mcp111   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _