Article - CS333210
Dynamic Table Always Moves the First Record When Using 'Move Last Tag' While Connected to a Large Table in Access
Modified: 02-Nov-2020
Applies To
- Kepware Server (formerly KEPServerEX) 5.19.467.0 to 6.8
- ThingWorx Kepware Server (legacy) 8.0 to 8.4
Description
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.
This is a printer-friendly version of Article 333210 and may be out of date. For the latest version click CS333210