Microsoft KB Archive/290382

= You receive an ADO timeout error when you modify the structure of a large table in Access 2002 =

Article ID: 290382

Article Last Modified on 8/10/2004

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q290382



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).



SYMPTOMS
When you are modifying the structure of a table in a Microsoft Access project (ADP) file, you may receive the following error message:

ADO error: Timeout Expired



CAUSE
Microsoft Access is timing out while waiting for Microsoft SQL Server to make the requested changes.



RESOLUTION
Set the OLE/DDE Timeout option to a higher value, or set it to zero (0) to never time out. To set the OLE/DDE Timeout option, follow these steps:
 * 1) Start Microsoft Access.
 * 2) Open your Microsoft Access project (ADP) file.
 * 3) On the Tools menu, click Options.
 * 4) Click the Advanced tab.
 * 5) In the OLE/DDE Timeout box, type the value in seconds for Microsoft Access to wait before a time out occurs. To avoid time outs, set the value to 0.
 * 6) Click OK to close the Options dialog box.

NOTE: You must quit, and then restart Microsoft Access for the new setting to take effect.



MORE INFORMATION
Microsoft Access uses the OLE/DDE Timeout option to determine how long (in seconds) it should wait before a time out occurs. By default, the OLE/DDE Timeout option is set to 30 seconds. The OLE/DDE Timeout option has a range from 0 to 300 seconds. If you set the value to 0, then no time out will ever occur.

Additional query words: prb time-out time-outs

Keywords: kberrmsg kbprb KB290382

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.