访问SQL Server链接表，限制记录数 [英] Access SQL Server linked tables, limited # of records

问题描述

我已经将一个大型SQL Server表链接到Access，但是仅''

2,195,439条记录显示并可供查询。我可以增加

大小（缓存??）/ Access中显示的记录数量吗？


谢谢。

I have linked a large SQL Server table to Access, however ''only''
2,195,439 records are shown and are available to query. Can I increase
the size (cache??)/number of records showing in Access?

Thank you.

推荐答案

br ******** @ yahoo。 com 写道：

我已经将一个大型SQL Server表链接到Access，但是只有
2,195,439条记录显示并可供查询。我可以增加显示在Access中的记录的大小（缓存??）/数量吗？

I have linked a large SQL Server table to Access, however ''only''
2,195,439 records are shown and are available to query. Can I increase
the size (cache??)/number of records showing in Access?

为什么在地球上你会对用户这样做？谁想要浏览那些

多条记录？你想走另一条路，限制所显示的

记录的数量。


-

这条信号故意留空

Why on Earth would you do that to your users? Who''d want to browse that
many records? You want to go the other way and restrict the number of
records shown.

--
This sig left intentionally blank

您希望采用相反的方式并限制显示的
记录数量。


我知道怎么做。我无权在SQL Server上存储查询/ sp，而我需要为最终用户制作一个灵活的应用程序。

谁想要浏览那么多记录？

You want to go the other way and restrict the number of
records shown.
I know how to do that. I do not have permission to store a query/sp on
the SQL Server and I need to make a flexible app for an end user.
Who''d want to browse that many records?

应用程序需要能够建模所有历史数据

Application needs to have ability to model all historical data

2005年3月25日10:22:46 -0800， br ******** @ yahoo.com 写道：

On 25 Mar 2005 10:22:46 -0800, br********@yahoo.com wrote:

你想走另一条路并限制显示的
记录数。

You want to go the other way and restrict the number of
records shown.

我知道怎么做。我没有权限在SQL Server上存储查询/ sp，我需要为最终用户制作一个灵活的应用程序。

I know how to do that. I do not have permission to store a query/sp on
the SQL Server and I need to make a flexible app for an end user.

你不要不需要服务器访问，只需创建一个Access查询。 Access将提交

SQL到服务器，服务器将检索选定的行到

Access。

You don''t need server access, just create an Access query. Access will submit
the SQL to the server, and the server will retrieve the selected rows to
Access.

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