My app always gets old record ?

[Albert]

Please read until finish, I not ask about Access....I ask about W2K Server
===========================================

I have a problem that my program (Access 2K + ADO + JET) always get the
record that its value is earlier before updated. If I write code to wait for
4-5 seconds before I get that record, This time I get the correct value. I
think this is problem about synchroniation between cache and actual data in
HD. Is there any parameter in Windows 2000 Server I can set to solve this
problem ? Actually, I'm not sure this is Win2K Server problem or It may be
other layers, HW / ADO / OLE DB Provider for JET / ...

Any help is very appreciated, thank you.

PS : I tests the same program on another pc with WinXP, No problem is found.

 

[Bob I]

Perhaps you should abandon this and ask in the Server newsgroup instead.