New to programming world...

[James Stanich]

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...

[Clunietp]

This is why we use Autonumbers/Identity fields -- the DBMS worries about the concurrency