| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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"? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to store a connection with parameters into a workbook | Excel Discussion (Misc queries) | |||
| reconnecting a workbook connection from Access-Excel | Excel Discussion (Misc queries) | |||
| Problems with listboxes in connection with screenupdating = false | Excel Programming | |||
| using ado db connection in different workbook | Excel Programming | |||
| Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming | |||
![Tim Lund[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
