Victoria @ WB wrote:
It starts to run well and then it stops and I get the same error. The debug
returns at line:
QT.Refresh BackgroundQuery:=False
Since that is the line that actually does the query, that will be where any
problems show up.
I suspect your suspicion about not enough connections to the database might
be correct.
Since the problem is still happening when we have forced the refreshes to be
sequential I have gone off that idea.
Is it always the same query that fails?
Is it a query that takes a long time and therefore might hit a timeout?
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|