adAsyncExecute

[luca90]

In wich case i need to use this param in ADO connection with access and vb6 classic?
Tks.

[Hack]

http://support.microsoft.com/kb/190988

The example given is for reference only. It uses SQL Server as a back end which is when you would probably use adAsyncExecute - I can't image why you would ever use it with Access.

[tkorsano]

hi there,

according to this page --> http://www.bigresource.com/VB-adAsyn...rJ2CAqDTi.html it rocks!

the point of this loop:

' Poll the command status
While (Comm.State And (adStateConnecting Or adStateExecuting Or adStateFetching)) <> 0
DoEvents
Wend

is that doevents will update your windows form while this db command is executing, like a classical progress bar display.

so what is he missing?
his cpu goes to a 100%.
it surely does... because of this loop.
so, a good guess for a fix would be (maybe):

' Poll the command status
While (Comm.State And (adStateConnecting Or adStateExecuting Or adStateFetching)) <> 0
DoEvents
Sleep(1000) 'it will sleep for a second with each loop iteration, thus cpu will not be pegged
Wend

that's it,

tonci korsano