Command timeout

  • Thread starter Thread starter Nikola Milic
  • Start date Start date
N

Nikola Milic

Hi,
I have long running query. How can I increase command timeout for report?

I'm using Access 2000 adp at SS2000 Enterprise edition SP3 on Win2000
Advanced Server SP4.

Thanks in advance
Nikola Milic
 
There is no place to really impact the default command time out used by
Access when it starts a connection (i.e. you can't set the CommandTimeout
property of the currentproject.connection), but since ADO is really an OLE
activity as well, you can also try modifying the OLE/DDE timeout which is in
the Tool->Options -> Advanced tab; where an setting can go as high as 300
seconds; a value of 0 indicates infinite wait. (the default is 30 seconds).

If that doesn't solve your problem, you can manage the time out on
individual command executed in code by setting its specific CommandTimeout
property. So if your report is based on an SP, you could write that out to
a table and wait for its return before opening your report based on a view.
 
Back
Top