Help-ODBC Error when query runs

  • Thread starter Thread starter RobSol
  • Start date Start date
R

RobSol

I keep getting an error message when I try running a query linked to a SQL
Table. The error is

Run-time error '3157'
ODBC-Update on a linked table ‘tbl_XXXX’ failed.
[Microsoft][ODBC SQL Server Driver]Timeout expired(#0)

Anyone know how to eliminate this error from occurring? Is there a setting
in my Access DB I can adjust? Any help would be great!!
 
The default value for ODBC timeout for queries is 60 seconds. You can find
this property in the Properties Dialog box for the Query (in query builder
view, right click on the top panel, where the tables go, and choose
Properties). Change the timeout value to something higher or to zero for no
timeout.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
The default value for ODBC timeout for queries is 60 seconds. You can find
this property in the Properties Dialog box for the Query (in query builder
view, right click on the top panel, where the tables go, and choose
Properties). Change the timeout value to something higher or to zero for no
timeout.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Back
Top