[AccessD] Query Timeout Problem

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.