Selasa, 19 Juli 2011

Re: [MS_AccessPros] Timeout on SQL Query (to SQL tables) built and launched in Access

 

What is a pass-through query?  Also, this is an 'Insert into' query into a local temp table.

From: Duane Hookom <duanehookom@hotmail.com>
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Sent: Monday, July 18, 2011 2:45 PM
Subject: RE: [MS_AccessPros] Timeout on SQL Query (to SQL tables) built and launched in Access

Have you considered using a pass-through query? This resulting recordset is not updateable but it's much much more efficient.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: mikewolfstone@yahoo.com
Date: Mon, 18 Jul 2011 21:24:54 +0000
Subject: [MS_AccessPros] Timeout on SQL Query (to SQL tables) built and launched in Access

 

I keep getting a SQL timeout error (#3146) on a query built in Access and launched in Access against a couple of SQL Server (2005) tables.
I have tried setting timeout values several ways, but none seem to work.
Does anyone have a foolproof ODBC way to set the timeout to 0 so the query will not timeout?
My most recent attempt is: CurrentDb.QueryTimeout = 600 ' tried 0 also
The query is launched as: docmd.runsql sqlstring, false
Any thoughts?
Thanks

                       

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar