How to speed up data-access on Access 97 DB with BDE

How to speed up data-access on Access 97 DB with BDE ? It's so slow for 2-3
fields on 2 related tables.
Thanks a lot for answering.