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

This article was previously published under Q290382
This article has been archived. It is offered "as is" and will no longer be updated.
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.
prb time-out time-outs
Properties

Article ID: 290382 - Last Review: 10/26/2013 17:48:00 - Revision: 4.0

  • Microsoft Access 2002 Standard Edition
  • kbnosurvey kbarchive kberrmsg kbprb KB290382
Feedback