Query timeout

  • Thread starter Thread starter Guy Horton
  • Start date Start date
G

Guy Horton

Hi,

Is there an menu option in an Access ADP that allows you to globally change
the default command timeout (currently 30 seconds). As I have a number of
reports with stored procedure recordsources that are failing because they
are timing out.
Ideally I don't want to have to go through all the reports programatically
executing the stored procedure with a modified ADO command commandtimeout
property and assigning the resultant recordset to the report.

TIA
Guy
 
You change the timeout for the "general access connection" (not your own
defined
ADO.Connection object) on the menu:

tools->options->Advaced -> OLE/DDE timeout sec.

Not sure why, but it works...
You can also do it with VB something like:

Application.SetOption "OLE/DDE Timeout (sec)", 60

(set conn. timeout to 60 Sec)

perove
 
Perove,

Thank you for your response.

Does this option modify just the connection timeout, or both the connection
and command (query) timeouts?

It was the latter that I was interested in.

Cheers
Guy
 
Back
Top