D5 using Access 97 mdb with linked ODBC tables - slow performance

Victor Lesniak

Delphi Developer

Sat, 10 May 2003 10:56:22 GMT

D5 using Access 97 mdb with linked ODBC tables - slow performance

Any one know why ...
I have an Access 97 mdb with linked tables that are connected via ODBC using
BDE.
In Access, the performance is alright when opening one of the linked tables.
When my Delphi app accesses via sql or clientdataset componets via BDE, very
slow retrieval.
I had considered using ADO but the express componets don't link linked
tables via ODBC and it is very slow.

Any help would be appretiated.

Victor

Other Threads

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

2. Installing ODBC for use with Access 97 .mdb file

3. Slow performance Access 97/Delphi 4

4. Slow Performance with Access 97 and D4

5. D5 w/SQL Server 7 via ODBC - Slow Performance

6. how do i start another app and accessing access 97 mdb's

7. Access to *.MDB (Access 97) databases.

8. Using ADO with D5 and access 97

9. D5 and Access 97 Table

10. Opening an Access 97 file using D5