Article ID: 2730109 - View products that this article applies to.
Consider the following scenario:
ODBC--call failed: [Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host (#10054) [Microsoft][SQL Server Native Client 11.0]Communication link failure (#10054)
Note This issue may also occur when you try to open the linked table from other applications that are connected to the SQL Database instance table by using Microsoft Open Database Connectivity (ODBC).
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
To work around this issue, use one of the following methods:
For more information about Access 2010 and SQL Database (referred to as SQL Azure on this blog), go to the following Microsoft Office blog:
Access 2010 and SQL AzureFor more information about query performance in an Access database, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/209126/ )Information about query performance in an Access database