Force to flush data to HD

[Albert]

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 synchronization between cache and actual data in
HD.

More info : My code is in Form_AfterUpdate event of sub-form. Sub-form is
bound form. RecordSource of sub-form is taken from linked table.

Can I adjust the period of time that Access wait before it write data to HD
?
or
Can I force Access to flush data in beffer to HD ?

Any help is very appreciated, thank you.

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

 

[Wayne Morgan]

Try the RefreshCache method of the Jet Engine Object (JRO).

 

[Albert]

Thanks so much, so much, so much, ... you help my life.