background threading in vba?

[rmanchu]

is this possible at all?

my problem is this. i have an access application which on startup and
successful logon, downloads 8 recordsets over the internet. the time
varies between 5 secs and even 25 secs in extreme cases.

app:: startup ---> logon ---[download 8 recordsets]---> switchboard

i would like to start downloading the recordsets (there is no security
concerns here) right after startup and in parralel to the logon
process.

would like to give a better user experience => better response times
during startup.

thanx
riyaz

 

[TC]

IIRC, someone used to market a DLL which ws meant to allow
multithreading from VB. Unfotunately I can't remember what it was
called. And there is probably no guarntee that it would work with VBA.

I do know that you can /NOT/ do it by calling the relevant win32 API's
directly (CreateThread etc.). Don't even try.

HTH,
TC (MVP Access)
http://tc2.atspace.com
(off tomorrow)