app is too fast ??? what is going on?

[tolisss]

Hello over there

develop an app that add some contects to an access db using ADO.the problem is that is u press the save button too fast about 8-10 times u get an error that the "table is locked; could not update" and u get that error in different line evry time.
what is going on??? can somebody clear things up?? read about RecordsetChangeComplete event of the recorset object can i use it to tell which table is locked how can i wait for that table to unlocked and the do next addition.I hope i didn't confuse u

thnks

[makai]

you are trying to call a server object (DB provider) before a previous call is returned

the lock is a self protective device of the server object

- reentrancy is also a problem on your client end

either stop clicking or place a boolean flag that will not allow you to make the call (i.e. Exit Sub) until after the first call returns (when you reset the flag)