Bill:
It starts to run well and then it stops and I get the same error. The debug
returns at line:
QT.Refresh BackgroundQuery:=False
I suspect your suspicion about not enough connections to the database might
be correct. When I was refreshing each query seperately the other day, half
way through the error popped up. I shut down my Excel file and opened the
Access database. I activated the query in question and shut down Access.
When I returned to Excel and tried to refresh the same query, it worked again.
Do you know how to increase the connections to the database? Is it
something I need to discuss with my networking department?
Thanks for the help.
|