Access 2013链接表超时错误 [英] Access 2013 Linked table timeout error

问题描述

我在Access 2013中有一个应用程序，其中通过ODBC创建了链接表.链接表在后端连接到SQL Server.创建链接表后，双击它(以便在数据表视图中查看表)时，出现以下错误:

I have an application in Access 2013 in which I create a linked table via ODBC. Linked table connects to SQL Server in the backend. After I create a linked table, when I double click on it (in order to view the table in a datasheet view), I get following error:

ODBC调用失败

ODBC Call Failed

[Microsoft] [SQL Native Client]查询超时已过期(#0)

[Microsoft][SQL Native Client] Query timeout expired(#0)

我在网上进行了调查，但没有找到任何有用的信息(很少有人提到在Windows注册表中将查询超时值更改为0的信息，但是我不在这里执行任何查询，所以我不知道如何更改链接表的超时值).

I researched online but haven't found any useful information (there were few posts that mentioned about changing the query timeout value to 0 in Windows registry however, I am not executing any query here so I don't know how to change the timeout value for a linked table).

推荐答案

在查询的属性表上，尝试设置ODBC超时= 0.

On the property sheet for your query, try setting the ODBC Timeout=0.

这篇关于Access 2013链接表超时错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！