Hi,

I want to know, how to load data into clientís pc memory and get those data
updated
in the cache when they are updated on the server.

We have a VB6 application loading collection during the load phase of the
application.
Data are loaded thru ODBC sql server driver (we are using MS-SQL server 6.5).
Those data are queried very often and they are almost static (rarely modified).
When they are updated on the server, they arenít updated into the client
cache memory.
This sometimes cause integrity problem. Is there a way to make client cache
data refresh
when the data on the server are updated ? We want to generate few network
trafic,
we have remote site with small bandwith.

Regards.