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]
Selasa, 19 Juli 2011
Re: [MS_AccessPros] Timeout on SQL Query (to SQL tables) built and launched in Access
__._,_.___
MARKETPLACE
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar