[AccessD] How to Force ODBC Timeout

Rusty Hammond rusty.hammond at cpiqpc.com
Mon Apr 22 15:53:55 CDT 2013


I have to ask, is the recordsource of the query an ODBC based data
source (ie a Linked table referencing a SQL database table) or is it
just an Access table?

Rusty


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Monday, April 22, 2013 3:22 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] How to Force ODBC Timeout

All, 

I would like to test the error handling of ODBC Timeout errors.

I set a test query's ODBC Timeout to 5 seconds.

When I open the query from VBA code, it takes about 40 seconds to open.

There is no ODBC Timeout error generated, however.

I must be missing something.

Thanks,
Brad

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************



More information about the AccessD mailing list