-
Hello.
I am creating a VB program which will use 3 Access databases. One of the databases will contain groups of 4 specific types designated by RR, LW, CS, and so on. I have been adding one to the next record to detremine the next number when a user selects to add a group.
My worry:
If this program were to be installed on a network and multiple users accessed the program at the same time,
1) Who gets the next number if two user adds a goup at the same time?
2) If one user cancels, and say he would be adding new Group 3, and another user, at the same time gets Group 4, won't I have problems when the next user logs on as he would also get Group 4 (the counting method I mentioned earlier). Can someone provide a method of retreiving the next number without using the count method I have mentioned?
Any help on this would be appreciated...
-
This is why we use Autonumbers/Identity fields -- the DBMS worries about the concurrency :)
