background threading in vba?


R

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
 
Ad

Advertisements

T

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top