You receive an ADO timeout error when you modify the structure of a large table in Access 2002 (290382)
The information in this article applies to:
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:
- Start Microsoft Access.
- Open your Microsoft Access project (ADP) file.
- On the Tools menu, click Options.
- Click the Advanced tab.
- 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.
- 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.
| Modification Type: | Minor | Last Reviewed: | 8/10/2004 |
|---|
| Keywords: | kberrmsg kbprb KB290382 |
|---|
|