has anyone found that when using the Microsoft.Jet.OLEDB.4.0 Provider with
ADO to access an Access 97 MDB that retrieved ADODB.Recordsets which obtain
all records in a Table are in fact missing the final record ?  i am building
server-side read-only cursors

"select * from tablename" on a table with 3 records will only return 2
records.

i couldn't believe my eyes at first, but after a lot of testing this is the
conclusion i have reached.

i am coding in VB6 SP3, NT4 SP5, latest MDAC (I checked the Microsoft
web-site today)

Hey John,
We are having a similar problem with ADO and OLEDB 4.0 and Access 97. The
recordset does not return all records our platform is
 VB6 SP3,  Novell 4.11, Latest MDac Access 97
It only happens in Novell though and it works OK with NT4.  We haven't found a
solution but please let us know if you find something.

Thanks

Raj