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).
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
Microsoft Access is timing out while waiting for Microsoft SQL Server to make the requested changes.
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.
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.