検索機能を使用して 500 を上回る Kepware の知識ベース記事の中から閲覧します。結果を絞り込むか、クエリーを下部の検索フィールドに入力します。

解決策が見つからなかった場合には、当社の PTC eSupport Portal で追加資料を確認することもできます。eSupport Portal へのログインを要求された場合、My Kepware の認証情報を使用できます。My 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/07

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