[AccessD] Change ODBC timeout default query property

O'Connor, Patricia (OTDA) Patricia.O'Connor at otda.state.ny.us
Tue Aug 22 08:46:57 CDT 2006


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
* 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.



More information about the AccessD mailing list