Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Jason0001
-
ADO Async call to database with Recordset Object not Working
That should work, but unfortunately, the code doesn't actually execute the sql statement until the "if rs.EOF" line. When I do the: ****************************************** Set rs = cmCIS.Execute(, , adAsyncExecute) Do While (cmCIS.State And adStateExecuting) = adStateExecuting...- Jason0001
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
ADO Async call to database with Recordset Object not Working
I am trying to perform an async call to an Oracle database. The code skips right through the execution of the statement (without running the sql), then hangs when I check to see if the recordset is at the end of file. The code is in Excel, but really could be in Access or even VBScript, for...- Jason0001
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
