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