Hi

I've made an application that runs over a LAN. It uses MS Access 97 databases.

These databases will eventually get to about 15000 records.

I'm using DAO in code and a few ADO controls.

Does the whole database have to be copied into the computers memory for it to be used?

What sort of speed can I expect from the DAO when accessing a database this big?

I use code similar to this...

Dim db As Database
Dim rs As Recordset
Dim recordsource As String

recordsource = "SELECT * FROM stock WHERE cid = " & cID & " AND aid = " & aID

Set db = OpenDatabase(recordPath)
Set rs = db.OpenRecordset(recordsource)

If rs.BOF = False Then... blah blah blah

endif

rs.Close
db.Close


Does an Access database only send the data requested?

Also, I've seen on the MSDN somthing about pre-loading the database so that there isn't a pause when the app is first run. How can this be achieved?

This is quite urgent and I appreciate any help offered.