Can I pre-load a recordset?

[PaulB]

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.

[Maartin]

Some more info about accessing it. Access the database to get recordsets connnect to the database ?

But use snapshots(read only) where possible, and dynasets when you have to write. Get ride of the datacontrols ONLY USE recordset. Ont recordsets you can also set the amout it is alowed to store in memory.

I asked Microsoft the very same question but then there was no RDO OR ADO. But the reply was use recordsets where data acceess is needed and use recordset to get info not dynasets or tables.

Need more info contact me @ [email protected].

Going Home it is 4:00 pm.


------------------
Have Fun.
Maartin.
[email protected]
-----------------------