our ACCESS 97 application connects to SQL Server. When retrieving a
large number of records we sometimes get an ODBC timeout.
(maybe due to a heavy loaded SQL Server)
This sometimes makes it impossible to execute the query for quite a
long time (in some cases for several hours !!)
Where can I change the number of milliseconds when ACCESS timeouts the
May changing the query to ODBC direct or SQL pass through be a
Please answer also by email.
Many thanks in advance for your help,