run ADODB connection as a background query

[George]

Hi All,

I've been using Excel to pull together data from our SQL server database (I know, probably not the right tool for the job) with ADODB connections. This works fine when I'm onsite, but when I run it over the internet the connection is too slow, so the macros finish executing before the data is updated, so some macros which depend on this data are producing incorrect results. Basically, is there a way to force an ADODB connection not to run as a background query (like you can with the "Data From Other Sources" thing)?

Thanks,

George.

 

[George]

wow, can't believe I've managed to stump the ninjas - guess this either isn't possible or I should try and find an Access help place and co-opt it for excel.