I am working with a MS Access database table of some 1600 rows by 8 columns. The data is numerical.

A path is established from an ADODC control to the Access table, and a DATAGRID on the form is linked to that ADODC.

This more or less works fine. The Access table data is shown in the DATAGRID.

HOWEVER, a problem variously arises after row 1000. For the most part all the data looks good, but chunks of row groups appear out of sequence with respect to their column 1 (ID Field) numerical value when viewed in the DATAGRID. The ID values are correct, but in the DATAGRID they appear out of sequence. Yet when the Access table is viewed using the MS Access program, all rows appear in their correct numerical sequence and the table looks fine.

Hence when I use such commands as ADODC3.Recordset.Movenext (or Moveprevious etc.) I can not be certain which row no. will be read. It will be the next row as displayed in the DATAGRID and not necessarily the next row in ID. number sequence.

This problem only arises (so far) for row ID numbers greater than 1000.

Ideas requested please. Is there some limit as to the number of Access table rows which VB6 ADODC / DATAGRID can correctly handle?

camoore

Wales, UK