使用搜索功能查看 Kepware 的信息库,其中包含 500 多篇知识库文章。缩小搜索结果范围,或在下面的搜索字段中输入您的查询。

或者,如果您无法找到解决方案,我们还有另一个资源:我们的 PTC eSupport Portal。 如果系统提示您登录 eSupport Portal,您可以使用“我的 Kepware”凭据。需要一个“我的 Kepware”帐户吗?在此处创建

搜索解决方案结果:
View All Solutions

Kepware Knowledge Base: Solution


Dynamic Table Always Moves the First Record When Using 'Move Last Tag' While Connected to a Large Table in Access


Last Update: 2018/11/7

Problem:
There is a bug in the low-level Microsoft ODBC Driver for Access. When users that have a table containing over 500 records attempt a Move Last, Move To, or Move Next past the five hundredth record, the ODBC Client driver will reset the pointer to the first record.

Solution:
1. To always display the last record, create a query in Access and then connect to that instead of the actual table. Users can also do the following:

  • Query the data base and then do a decreasing sort so that the last record is always the first record.
  • If the data table is going to be very large, query the database to only bring back the last few records and then do a decreasing sort. The larger the data table, the longer it will take for the ODBC Client driver to pass the data back to the server during a query interval.

2. Do a specific query for only the last record.

Related Products
KEPServerEX, ODBC Client