How to sort out the locking issues in MS access , we have a client who is running a supermarket , they have 5 cashiers who will be accessing the same receipt form , now I'm worried about the locking issues. How can I deal with the locking system so that all the 5 cashiers will able to use the same form and save data at same time otherwise if the other cashiers have to start waiting for one cashier to save data I'm afraid there will huge ques in the supermarket. All the 5 cashiers will have their own FE and the BE will be on their server and will be accessed through the network by all.
Regards
Chris
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.