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