[AccessD] How to Force ODBC Timeout

Brad Marks BradM at blackforestltd.com
Mon Apr 22 15:58:11 CDT 2013


Rusty,

The data is coming from a Pervasive Database (Purchased Accounting
System) via a Linked Table.

Brad


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

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
This message was scanned by ESVA and is believed to be clean.
Click here to report this message as spam. 
http://h0stname/cgi-bin/learn-msg.cgi?id=78D7D27E17.44D8F





More information about the AccessD mailing list