[AccessD] How to Force ODBC Timeout

Rusty Hammond rusty.hammond at cpiqpc.com
Tue Apr 23 14:16:17 CDT 2013


Does your query have multiple linked tables that it's querying together?
Could be the data is coming back quickly from the pervasive table, but
the work in relating the data in the multiple tables is what's taking
the time.  What happens when you simply open the linked table in the
front end, does it start showing data immediately?

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:58 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How to Force ODBC Timeout

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



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