Article ID: 290382 - View products that this article applies to.
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:
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.