ODBC timeout

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

 

[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

 

[Duncan via AccessMonster.com]

Hi John,

Thank you for your prompt response! Really appreciate it!

Regards,
Duncan.

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,

[quoted text clipped - 5 lines]

Thanks and regards,
Duncan.