Please!
I use ado and access 2000.
When the mdb is in c:\...mdb all operation are very very fats similar update, delete find sql command ecc...
But when i svae the same mdb on network dir the time of release operation is very slow, slow, slow...

Please... "10 gold rules on access database in network dir"...
Tks.

And you are asking why?? because in a network (if my memory doesn't fail) the driver get all the table, not only the subset of data you need.
Then on your side it choose the correct data that you want.

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========