ODBC timeout

  • Thread starter Duncan via AccessMonster.com
  • Start date
D

Duncan via AccessMonster.com

Hi,

I have written a UNION query and would now like to set the ODBC timeout
interval for this query to zero. How do I do that? Also, is there any way by
which I may set the global ODBC timeout parameter that acts as the default
for all queries that get created in the future?

Thanks and regards,
Duncan.
 
J

John Spencer

Open the union query in design mode.
Select View: Properties from the menu
Set the ODBC Timeout to zero in the properties sheet

I am not aware of a method that would automatically do this for all future
queries.

Since this is a query property, I would assume that you could write a VBA
function that would step through all existing queries and set the property.


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
D

Duncan via AccessMonster.com

Hi John,

Thank you for your prompt response! Really appreciate it!

Regards,
Duncan.

John said:
Open the union query in design mode.
Select View: Properties from the menu
Set the ODBC Timeout to zero in the properties sheet

I am not aware of a method that would automatically do this for all future
queries.

Since this is a query property, I would assume that you could write a VBA
function that would step through all existing queries and set the property.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
Hi,
Click to expand...
[quoted text clipped - 5 lines]
Thanks and regards,
Duncan.
Click to expand...
Click to expand...
 
Top