ODBC call - need to change value for Estimated Query Time

[Guest]

I have a file that makes an ODBC call to a remote database. I had to append
some code to the file recently, and after I made changes one query inside my
file is over the max allowed value of my Estimated Query Time (queries less
than 60 are allowed to run).

So my query can not run because it now estimated as taking 60 to run (assume
60 mins). So my question is where this setting is, as I would need to change
the value to 61 so I can run it.

 

[Harley Feldman]

Open up the query in design view. Click on the properties icon. "ODBC timeout" is one of the properties.

Harley