[AccessD] Query Timeout Problem

You can set the timeout directly in the query properties. 

Open the query in design view. 
Right click the top pane or otherwise open the properties dialog. 
Look for ODBC timeout.

I have no idea if 0 is a valid value in this property.  0 means wait 
forever.

John W. Colby
www.ColbyConsulting.com



Kaup, Chester wrote:
> I have a query that uses three SQL server tables linked by ODBC. The query runs OK in the query grid with the query timeout set to 0. When I try to run the SQL statement in VBA it returns an ODBC connect failure message indicating to me that it time out. Here is some of the code. Maybe I am setting the timeout wrong?
>
> Dim MyDb As DAO.Database
> Set MyDb = CurrentDb()
> MyDb.QueryTimeout = 0
>
> strSQL = "some query statements"
>
> Set RS3 = MyDb.OpenRecordset(strSql)
>
>
>
> Chester Kaup
>
> Engineering Technician
>
> Kinder Morgan CO2 Company, LLP
>
> Office (432) 688-3797
>
> FAX (432) 688-3799
>
>
>
>
>
> No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.
>
>