I have an MS Access 2K application with a split FE/BE configuration.
The workstation is XP Pro and MS SQL SERVER 2008 R2 is installed on computer via LAN.
Other databases are Access 2K on a windows 2K server.
This is a windows 2003 server enviorment.
I'm running a very long routine...on 10,000 + records... The routine loops through each records and creates HTML code that can be uploaded to a website.
The routine fails after looping approximately through 10,000 records. I get the following error:
[Microsoft][ODBC SQL Server Driver]Timeout expired
Can anyone help?