I have an Access 2013 database with tables and views linked from SQLServer. I am transferring from the adp that I used in Office 2010. I keep running into the problem of reports, based on linked views, not running because an ODBC timeout. The timeout seems to be the default value of 60 seconds. I have tried using CurrentDB.Timeout = 180, but that does't seem to have any affect.
Can I change the timeout and, if so, how.