There is a network contractor who claims that on a local network, when FPW2.6 accesses data,( like when doing a select) accessing data on the server from a local computer, the data is cached in Memory ON THE Server! This causes the server to require a lot of memory for data intensive programs.

I have always believed on a network that Fox creates its temp tables locally as well as cache's all the data locally in memory.

Could someone please shed some light on this.

Thanks

Bernard