Access Client, SQL Server backend.
In the Access client I am linking to a view on SQL Server.
The view is taking a long time to process, and eventually times out.
The same view takes a long time to return (in SQL Server Query Analyzer) but finishes.
I am looking at 2 options:
1) Wrap a Pass Through Query around the View and use the Pass Through Query ODBC Timeout property to help with the timeout issue.
2) Increase the timout for the View in the Access client (Is this possible? I didn't see a "Timeout" property for a View like I did for a Pass Through query)