
ADO Jet 4.0 performance problem vs Jet 3.51
Simon,
What happens if you upgrade the database itself to version 4.0?
--
Regards
Carsten Thomsen
MCSE/VB Programmer & Analyst
PLEASE post ALL replies to the newsgroup(s) so we can all benefit from the
discussion!
Quote:
> I have created an Access database with approximately 100 fields and am
> using Visual Basic 6 to access the file and am using DataEnvironment ADO
> connection.
> If I use Jet 3.51 DB provider then the application works quickly and the
> recordset opens in 1 to 2 seconds on an average PC which is what I would
> expect.
> If I change the provider to Jet 4.0 the same recordset command (requeries
> etc etc) all take between 10-20 seconds at least.
> If I switch back to Jet 3.51 then it is fine again.
> My smaller databases (with less than 50 fields) are ok with Jet 3.51 and
> 4.0 so it seems to be something to do with the quantity of fields.
> Any idea's anyone as its driving me mad and I obviously would like to use
> Jet 4.
> Thanks in advance
> Simon