[RESOLVED -FINALLY :-) ] could not update; currently locked

[Muddy]

OK, strange development. It seems to be working now (thought its fooled me before). I changed the code to the following .... but WHY does it work? isnt status=0 closed? what's going on?

heres what I replaced my updates with:

Do While rst2.Status > 0 
                    DoEvents
                Loop
                rst2.Update
                Do While rst2.Status > 0 
                    DoEvents
                Loop
                frmStatus.Caption = "Saving"