ODBC TimeOut Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear All,

We have a database with over 100 queries with an ODBC timeout rate of 60
seconds. How can we change this globally so that the Timeout rate maybe
changes to higher than this, since network traffic is slowing the queries
down, or should this never be changed? Is there a global setting within
Access 2000 that will change this value. Or is it an ODBC thing!?

Thanks again for any advice offererred.

Alastair MacFarlane
 
freakazeud,

Thanks again for your help. I looked there before my post, but there is not
ODBC Timeout setting in the Advanced Tab. There are other timeout settings
but not one that states ODBC Timeout. What are the implictions to setting it
much higher and is the ODBC Timeout a property that you cange chage by
looping through the database queries.

Thanks again for your help.

Alastair
 
Hi,
queries themselves have an odbc timeout property.
You can change it by opening the queries property window (right click on
gray area in query design view). By default the timeout is set to 60! If you
set it to 0 then NO timeout will happen, or specify the amount you want
instead.
HTH
Good luck
 
Back
Top