Use the search and browse 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.

Search Solutions 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