链接访问数据库到SQL数据库 [英] Linked Access Database to SQL Database

问题描述

我有一个用户，其访问数据库链接到SQL数据库中的多个视图。

我已经验证该视图将返回超过900万行。

Access可以返回到链接视图的行数是否有限制。

谢谢，

解决方案

miguelh，

我尝试在MS Access 2016的文档中找到。

访问2016规格

但是没有任何可用于SQL View的信息。

我试图找到SQL服务器文档。

优化链接到SQL Server的Microsoft Office Access应用程序

其中转到&quo t;使用SQL Server视图"之后。

之后请参考点"查看限制"。

但遗憾的是，也没有任何可用的信息可以返回多少条记录通过MS Access链接视图。

所以目前我们没有关于此问题的任何信息。

您可以尝试提交您的反馈到"访问用户语音"以将此详细信息添加到"访问文档"。

访问用户语音

问候

Deepak

I have a user that has an access database linked to several views in a SQL database.

I have verified that the view will return over 9 million rows.

Is there a limit on how many rows that Access can return to the linked view.

Thank you,

解决方案

Hi miguelh,

I try to find in the documentation of MS Access 2016.

Access 2016 specifications

but there is no any information available for SQL View.

I try to find the SQL server documentation.

Optimizing Microsoft Office Access Applications Linked to SQL Server

in which go to "Working with SQL Server views" point.

after that please refer point "View Limitations".

but unfortunately there is also no any information available that how many records can return by the MS Access to linked view.

so currently, we don't have any information regarding this issue.

you can try to submit your feedback to Access User Voice to add this details to Access Documentation.

Access User Voice

Regards

Deepak

这篇关于链接访问数据库到SQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！