Microsoft.Jet.OLEDB.4.0 Provider not working with Access 97 MDB 
Author Message
 Microsoft.Jet.OLEDB.4.0 Provider not working with Access 97 MDB

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)



Wed, 05 Jun 2002 03:00:00 GMT  
 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)



Sat, 10 Aug 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Jet.oledb provider with Access 97

2. Command.Execute with parameter works with ODBC provider, fails with Microsoft.Jet.OLEDB.4.0

3. ADOX, Jet OLEDB 4 & Access 97 .mdb

4. Microsoft.Jet.OLEDB.3.51 provider not registered

5. ADO OLEDB will not work on Access 97

6. Microsoft Jet OLEDB Provider 3.51: Does it support parameterized querys

7. Microsoft.Jet.OLEDB.4.0 OLE DB provider

8. Updating child recordsets using the Microsoft.Jet.OLEDB.3.51 provider

9. Provider=Microsoft.Jet.OLEDB.4.0 vs 3.51

10. How can I add Microsoft Jet OLEDB 4.0 Provider with my PDW Setup Files

11. Replace OLEDB provider Jet 3.51 with Jet 4.0

12. TransferDatabase method from Access 95 mdb to Access 97 mdb

 

 
Powered by phpBB® Forum Software