Problems with ADO connection to same workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook in which I have an ADO connection to itself, so that I can
use SQL to get arrays of data I want for processing in VBA. But I suspect it
is responsible for intermittent instabilities - typically an ADO related
error message about 'Network connection may have been lost'. Does anyone
recognise this problem? Is this self references connection object just
inherently flakey? Any "dos" and "don'ts"?
 
Back
Top