DBEngine.Idle dbRefreshCache

  • Thread starter Thread starter Albert
  • Start date Start date
A

Albert

Does it also flush data in cache to hard disk before refresh ? or refresh
only ? If refresh only, Have anyway to flush data ?

TIA
 
In my case, I want to flush data that Access write thru bound form. I found
that if I try to open recordset in Form_AfterUpdate event, I always get the
data that it was before Form_BeforeUpdate is executed. So, There is nowhere
to do workspace.committrans.

Someone told me to try JRO.RefreshCache CNN. It seems to work, I can get the
updated data. But I have to write with following code :

- wait for 1 seconds
- DBEngine.Idle dbRefreshCache
- JRO.RefreshCache CNN
- Define SQL Select Statement
- RS.Open SQL, CNN

I just only know that with above code sequence, it can work. But I don't
know exactly How does it work ? Which statement flush data ? or I can not
control, have to wait Access to flush by itself.

TIA
 
You can also get the fresh data from the form RecordSetClone.

(david)
 
Back
Top