ADO - connection gets lost? 1

[Dauphy]

I'm using VB6 and connecting to an Access 2000 database. I've written a program to loop through a table and create a query on the fly. That query updates query #2 and based on the results of query #2; a record may or may not be included in a new recordset.

This is my problem... the program works just fine; and then decides not to be able to find the query in the middle of the loop. And it's not always at the same record. It may process 5 records; and the next time it may process 10 records... This is the message that appears ... The Microsoft Jet Database Engine cannot find the input table or query query name. Make sure it exists and that it's name is spelled correctly. When I look at the database it does exist, so for some reason - it loses its reference to it. Has anyone encountered this problem???

Thank you.

 

[Chad123]

Hey,

You may need to set your CommandTimeout to something like 150 or so. Your query/queries may be working hard and timing out.

ex.
cn.open <parameters>
cn.CommandTimeout = 150

Chad

 

[Dauphy]

Thanks Chad: That must be it; before I increased it It wouldn't process more than 20 records; I got up to 124 this time.... I I need it to get up to 1,000; so I'll bump it some more.


Patti