Jet 4.0 Perfomance

[Mildumar]

Has anyone heard an explanation why Jet 4.0 is so much slower than 3.51?

I wrote a form with a ton of controls, and use ADO to get the data out of my Access 97 database. I just upgraded to the 4.0 driver from using the 3.51 driver and it now takes 30 seconds to load when it used to take 7 seconds.

Any ideas?

[JHausmann]

Is the databse you're opening on a network server? If so try creating an mdb of linked tables on your (local) machine). Then try running it.

[Mildumar]

Thanks for the response....

We are running it both ways, local and network. Depends on the department. Network is SQL. and very quick. The Local machine is JET. The time difference in loading the form between JET 3.51 and 4.0 is major (25 seconds).

Any suggestions?

[Clunietp]

Jet 4.0 provider is for MS Access 2000 (Jet 9.0) databases, while the 3 provider is for Access 97 (jet 8.0) databases. If you use Jet 4.0 on access 97 databases, the 4.0 provider read the older databases and convert the db properties on-the-fly to 4.0 so it can provide the new features of jet 4.0 provider, which you can imagine is a time consuming process, hence the big slowdown.

HTH

Tom

[Mildumar]

Thanks Clunietp, you hit the nail on the head.