ado automation error -2147467259

D

Dom

I keep getting the -2147467259 Automation Error while connecting to a table
using ADO and I'm wondering if this error is to do with the amount of time a
connection stays open.
The network I'm running it on is not the quickest in the world and the code
performs a series of calculations based on data from tables. It is possible
that 1 calcualtion could take up to 2 or 3 minutes.
Although the error occurs in 1 function it is not consistent i.e. it can
happen when I run the code once but work fine the next time.
Any clues or ideas?
Thanks
Dom
 
Top