M
Malee
Hello experts,
I have a bound main form with a bound continuous subform inside. My
algorithm need to update all records in bound subform again after each
subform's record was updated thru form. This algorithm can not be placed in
Form_BeforeUpdate event (of subform). I place it under Form_AfterUpdate
event. When code executes command RS.Edit (RS = Subform's RecordsetClone),
Error => "3197: The Microsoft Jet database engine stopped the process
because you and another user are attempting to change the same data at the
same time." is raised. If I trace line by line in my code, No error is
found. I think Although current subform recordset has just been updated
(pass Form_BeforeUpdate) , But it haven't been flushed into database
completely. So locking status is still reported to other processes. Question
is How can I force Jet Engine to flush that pending record ?
PS : I know there is dbForceOSFlush option for CommitTrans method, But
update is done by Access Form itself. So, I can not use this option.
Any help would be very appreciated,
Malee
I have a bound main form with a bound continuous subform inside. My
algorithm need to update all records in bound subform again after each
subform's record was updated thru form. This algorithm can not be placed in
Form_BeforeUpdate event (of subform). I place it under Form_AfterUpdate
event. When code executes command RS.Edit (RS = Subform's RecordsetClone),
Error => "3197: The Microsoft Jet database engine stopped the process
because you and another user are attempting to change the same data at the
same time." is raised. If I trace line by line in my code, No error is
found. I think Although current subform recordset has just been updated
(pass Form_BeforeUpdate) , But it haven't been flushed into database
completely. So locking status is still reported to other processes. Question
is How can I force Jet Engine to flush that pending record ?
PS : I know there is dbForceOSFlush option for CommitTrans method, But
update is done by Access Form itself. So, I can not use this option.
Any help would be very appreciated,
Malee