[AccessD] Problem of a listbox's response on network... Part 1

Mark Simms marksimms at verizon.net
Sun Jan 26 12:42:38 CST 2014


John - more importantly in this regard, there is no way to show a progress
bar indicating what percentage of the query records have been retrieved,
updated, inserted or deleted.
MSFT never thought to implement a callback routine that would trigger every
xxx seconds based on a parameter.

>
> I tried using ADO from Access to perform my SQL Server automation.  It
> worked but because of Access'
> single threading, when the query was running on SQL Server, the Access
> UI locked up tight.  Some of
> my queries take minutes or even hours.  Even though I was the only
> user, having the UI lock up like
> that left me wondering if the query was out to lunch or in fact ever
> going to finish.
> John W. Colby
>




More information about the AccessD mailing list