Frontend: Access2000
Backend: SQL 7.0
Connectivity: ODBC DSN
Database: SQL Database gets updated Manually on Monthly basis from many single Access DB’s. Data is just Append queried to update a single SQL DB.
Problem: This last month when I updated the SQL Server, all went fine. However, when I run my queries/reports from Access at my workstation (same network 100bt), I get the following messeage!
Message: [Microsoft][ODBC SQL Server Driver]Timeout
expired (#0)
I receive this message exactly 60 seconds after
depressing the run button. I have done a little research so far and found only one situation that is typical to my situation, it was per Microsoft to increase the QueryTimeout=60 to an increase amount of second in the registry, however, this did not work. I set it to 180
seconds but I still get the message after 60 seconds.
Any help is most greatly appreciated.
Thanks Randy