Report based on Stored Proc Timeout

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I have a report in an Access 2002 ADP project that is
based on a stored procedure that runs on a SQL 2000
server. If the procedure takes less than 30 seconds to
run, the report displays fine. If it takes more than 30
seconds, the report doesn't display. I have checked the
timeout value of the connection, and it is much higher
than 30 seconds. I also checked the timeout in ADO and
it is greater than 30 seconds too.
 
This turned out an OLE/DDE timeout. You can set this on
the Advanced tab of Tools, Options.
 
Back
Top