In my ADP I start a DTS pakcage from my vba module (use the object
dts.package2), I display the status of the progress in a pop up form.
My issue is the DTS package takes ages to complete and if a user use
another application and come back to the Access application the got a
pitch white screen like if the application crashed. Is there anyway to
force a refresh on the Access application? Any ideas are welcome.

You would need to use a separate thread for the execution as opposed to the
UI. Not sure if ADP will support this.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Xav" <Xaviar.Goulay (AT) uk (DOT) standardchartered.com> wrote