A
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.
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.