Clever Geek Handbook

ODBC access error for MS access. Request timed out

All I am trying to do is create 4 linked tables for 4 views in sql database. 3 of them work fine, the other is giving me this error when I try to open it. It will take a long time to open it from sql mgmt studio (almost 3 minutes). Internet search I can only find where people suggest to change the timeout property from the design view, but when I open the linked table in design view there is no timeout property to find. I can only see when I open the actual request. I've already increased the registry timeout property for QueryTimeout to 5 minutes, but I still get the timeout error after 60 seconds. Hope I make sense to someone :) Thanks for any help.

+3


source to share


1 answer


You can set the timeout in your ADO connection object or in the access database options. Here is a screenshot from Access 2013. Look for OLE / DDE timeout in client settings.



enter image description here

+8


source






More articles:


All Articles