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
As for potential conflicts when saving data, there are no generic answer, it is all up to the data model design and the policies you want to implement.