Access Locking records problem
I would like to find anybody help on the problem of access locking records. I have a backend data and front end application interface with multi-users database built for data entry. If one of the multi-users needs to update a piles of records with same criteria, may be 500 records or more at one time. When the updating not being finished, another users also come in for updating some of the recodes amongst the above piles of records. I want the 2nd/3rd .....users queue up and wait updating finished one by one.
What codes can i assigned in the program?