[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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 9
• New Files 8

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___