
Microsoft.Jet.OLEDB.4.0 Provider not working with Access 97 MDB
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
Quote:
> 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)