Hi, can someone provide me with VBA code to update multiple tables on a split backend.
There are 2 or 3 system interconnected to the same backend and my puzzle is when 2 systems are updating the same Item, one will freeze while the other will update successfully
I have been using queries to perform this task, but when 2 system are updating at the same time, one freezes-up and the application must be restarted before the system can operate again
Please I need quick solution to this challenge.
Thank you
There are 2 or 3 system interconnected to the same backend and my puzzle is when 2 systems are updating the same Item, one will freeze while the other will update successfully
I have been using queries to perform this task, but when 2 system are updating at the same time, one freezes-up and the application must be restarted before the system can operate again
Please I need quick solution to this challenge.
Thank you