o Jet Engine In ADO

Rann

Delphi Developer

Sun, 07 Nov 2004 22:12:11 GMT

Fast Access To MS Access 200 w/o Jet Engine In ADO

I am using ADO connections to a MS Access 2000 database and
Microsoft.Jet.OLEDB.4.0 as the provider. My efforts have resulted in
painfully slow record updates/appends. Is there a better provider out
there? I have been waiting for a dbExpress solution, but I don't think it
is here yet.

Any help or suggestions would be greatly appreciated.

Rann

Vassiliev V.V

Delphi Developer

Mon, 08 Nov 2004 14:31:22 GMT

Re:Fast Access To MS Access 200 w/o Jet Engine In ADO

Microsoft.Jet.OLEDB.4.0 is fast provider. However ADO and TDataset slow it.
Look OLEDB Direct at http://www.oledbdirect.com. Example
CreateAndFillJetTable shows the real speed of this provider.

BTW, Microsoft.Jet.OLEDB.3.51 provider is faster but less powerfull.

Regards,
Vassiliev V.V.
http://www.oledbdirect.com

P.S. Microsoft.Jet.OLEDB.X.X provider is fastest way to work with Jet
(Access) databases for now.

P.S. 2 dbExpress will never be faster because of its internal structure - it
will update database using SQL statements and OLEDB let insert/change/delete
directly on server-side cursor.

"Rann" <r...@umn.edu> ???Y/???Y ????? ???Y??:
news:3ceba741_2@dnews...

Quote

> I am using ADO connections to a MS Access 2000 database and
> Microsoft.Jet.OLEDB.4.0 as the provider. My efforts have resulted in
> painfully slow record updates/appends. Is there a better provider out
> there? I have been waiting for a dbExpress solution, but I don't think it
> is here yet.

> Any help or suggestions would be greatly appreciated.

> Rann

Other Threads

1. MS Access and Jet Engine

2. ADO - Jet 4 - MS Access - Compacting - D6

3. Access to Access tables, JET and ADO in the future

4. D5-ADO-MS ACCESS 97 database-MS Office 97 Access ODBC driver-Autoincrement probs

5. Problems with linking to access database using Jet engine

6. Request for Info: Jet engine access for Delphi

7. Delphi and Access Jet Engine

8. How to access MS-Access Reports with ADO?

9. Access 97 MDB file - ADO Jet 4 OLE DB

10. ADO Jet 4.0 & Access Db with password