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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using ADO to get data from Worksheet in Same Workbook 4
Populating a multi column listbox with ADO Recordset 2
ADO Connections 1
ADO connection error 2
import Excel worksheet to SQL Server table 7
ADO connection Open failure 5
ado connection to access vs. sql server? 7
ADO connection not always enabled 1

Back
Top