View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Lund[_2_] Tim Lund[_2_] is offline
external usenet poster
 
Posts: 3
Default Problems with ADO connection to same workbook?

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"?