[AccessD] Query Timeout Problem

Edward Zuris edzedz at comcast.net
Wed Apr 28 11:49:10 CDT 2010


 I use the value of zero for my long executing ODBC queries.

 The down side, if over the internet, wait forever can be a
 very long wait.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W Colby
Sent: Wednesday, April 28, 2010 9:49 AM
To: Access Developers discussion and problem solving
Subject: Re: [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.
>
>   
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list