ODBC Call Failed - Timeout

A

Atley

Help!

Timeout is happening after a really short time, I have an Access 2k Database
with Linked Tables to SQL Server 2k

Trying to export queries contents to Excel 2k via Macros.

How do I extend the Timeout limit?
 
V

Van T. Dinh

Each Query has the Property "ODBC TimeOut", usually set to 60 secs.

Check this Property of your Query and change it to something longer if
required.
 
Top