How to change default connection timeout for Access Project

[Peter Afonin]

Hello:

I need to change the default connection timeout for Access project. So I go
to File-Connection-Advanced and change the Connection Timeout from the
default 120 seconds to 600 seconds. But it doesn't work, it still remains
120 seconds. What could be a problem?

Thank you,

 

[Per Ove Steinsland]

You change the timeout for the "general access connection" (not you own
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