[AccessD] Change ODBC timeout default query property

Hi Patricia

Just located this info:

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B153756

This explains my observation as I didn't run a query, I only browsed the property sheet of a new query:

NOTE: When using the steps contained within Method 2 to set the QueryTimeout value within the registry, any new and existing query within Microsoft Access will continue to display a value of 60 for the QueryTimeout property. If the value set within the registry is greater than the value defined within the individual query, Microsoft Access will use the value within the registry to determine how long to wait before a QueryTimeout occurs. 

Also, setting a value of 0 (zero) will inhibit a timeout.

/gustav

>>> Gustav at cactus.dk 22-08-2006 18:37:28 >>>
Hi Patricia

It should be this Registry entry:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\ODBC]
"TraceODBCAPI"=dword:00000000
"DisableAsync"=dword:00000001
"TraceSQLMode"=dword:00000000
"QueryTimeout"=dword:0000003c
"LoginTimeout"=dword:00000014
"ConnectionTimeout"=dword:00000258
"TryJetAuth"=dword:00000001
"FatBlastRows"=dword:ffffffff
"FatBlastTimeout"=dword:00000003
"AsyncRetryInterval"=dword:000001f4
"AttachCaseSensitive"=dword:00000000
"FastRequery"=dword:00000000
"ODBCISAMAttach"=dword:00000000
"PreparedInsert"=dword:00000000
"PreparedUpdate"=dword:00000000
"SnapshotOnly"=dword:00000000
"AttachableObjects"="'TABLE','VIEW','SYSTEM TABLE','ALIAS','SYNONYM'"

Change QueryTimeout from 3c (60) to 258 (600) or 1770 (6000) or another value of your choice.
However, I just tried and it doesn't work for me with Access 2003 - maybe a reboot is needed.

/gustav


>>> Patricia.O'Connor at otda.state.ny.us 22-08-2006 17:52:36 >>>
Thanks Gustav 
But the problem is two fold. It is not for just existing queries but for
when they are making new queries. Forget to update the query property
and a special message pops up.   I know immediately I forgot when I get
the message and reset. Others don't understand the message and I usually
have to remind them.
 
I need a way to change this without having users run something special.

**************************************************
* Patricia O'Connor
* Associate Computer Programmer Analyst
* OTDA - BDMA
* (W) mailto:Patricia.O'Connor at otda.state.ny.us 
* (w) mailto:aa1160 at nysemail.state.ny.us 
**************************************************
 

> 
--------------------------------------------------------
This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments.  Please notify the sender immediately by reply e-mail and delete the e-mail from your system. 


-----Original Message-----

> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Gustav Brock
> Sent: Tuesday, August 22, 2006 10:41 AM
> To: accessd at databaseadvisors.com 
> Subject: Re: [AccessD] Change ODBC timeout default query property
> 
> Hi Patricia
> 
> You can set that property using DAO:
> 
>   CurrentDb.QueryDefs("qdyYourQuery").ODBCTimeout = 600
> 
> Of course, to carry this out create a loop that somehow 
> filters only those querydefs that have to be modified.
> 
> /gustav
> 
> >>> Patricia.O'Connor at otda.state.ny.us 22-08-2006 15:46:57 >>>
> Hi all 
> 
> Is there a way to set the ODBC timeout default  in the query 
> properties from 60 to 6000 permanently?  Most of our work is 
> against our ORACLE databases, some Foxpro, and SqlServer. For 
> every new query we do we have to remember to reset this 
> before running otherwise we get a timeout.
> Does not matter how easy or hard the query is, If it isn't at 
> least 600 then poof it stops.  One person said that it would 
> cause their MDB to corrupt but I haven't had that problem.  
> 
> The OPTIONS ADVANCED does not do this.  I have looked almost 
> everywhere but can't find out how to change the default.  
> This would be for 2k or 2k3.
> Any help appreciated 
> 
> Thanks
> 
> **************************************************
> * Patricia O'Connor