Query timeout

[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

 

[Per Ove Steinsland]

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

 

[Guy Horton]

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