I have a MS Access database that is linked to a MSSQL database through ODBC. The query has a where clause that retrieves records that fall into a date range. If I use a small range, lets say 30 days, the query works fine. If I increase the range to 60, I get the following error:
ODBC -- called failed.
[Microsoft][ODBC SQL Server Driver]
Timeout expired (#0)
I looked at other questions similar to mine on Experts-Exchange, and some of the suggestions asked to modify the timeout for the ODBC connection. Where would I find this setting? I didn't find anything in the ODBC settings. If there is another suggestion, I'll be glad to also give it a try. I'm using MS Access 2000 on a Windows XP machine. Thanks!