Use the search feature to view Kepware's repository of more than 500 Knowledge Base articles. Narrow your results or type your query into the search field below.

Alternatively, if you are unable to find a solution, we have an additional resource - our PTC eSupport Portal . If you are prompted to log into the eSupport Portal, you can use your My Kepware credentials. Need a My Kepware account? Create one here .

Search Solution Results By:
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: 11/7/2018

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