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 >