Hi

My app uses 2 MS Access 97 databases.

I access thes through DAO and a few ADO controls.

These databases will get huge eventually, and since my app runs across a 10Mbit/s LAN it will get very slow.

Is there anyway to speed this up.

When I use DAO I always close the DataBase object because my app is huge and there are so many parts that need to act independantly at the same time.


When the app accesses the database, does it load the whole thing, or does it just load the current record?


Thanks for any help that is offered.