two users cannot add a new data in the same form at the same time

[ilucks]

I have DB(Access 97) where multi- user work in a network.
Today, I encountered this problem.
Two users were in it and do edition and adding a new data on the same
form at the same time.
User 1 was adding data on the form (just say form A) and user 2 was
adding data as well on the same form(A) at the same time.
The problem is that user 2 could see data entered by user 1 on that
form(A) at that moment.
As I know, access handles problems like this by itself. Ex) provide a
warning...


Or something I have to check VB code?


My question?
Are there Adding conflicts in ACCESS 97 (windows XP) between multi-
user in a serve-based environment.


Again,
Two users are adding a new data on the same form at the same time.
Second user can see data, which first user enters on the same form.
Later, user 1 can see corrupted data on the form. The form displays
#Deleted.
how can i handle this?


Please advise.

[MMcCarthy]

I have DB(Access 97) where multi- user work in a network.
Today, I encountered this problem.
Two users were in it and do edition and adding a new data on the same
form at the same time.
User 1 was adding data on the form (just say form A) and user 2 was
adding data as well on the same form(A) at the same time.
The problem is that user 2 could see data entered by user 1 on that
form(A) at that moment.
As I know, access handles problems like this by itself. Ex) provide a
warning...


Or something I have to check VB code?


My question?
Are there Adding conflicts in ACCESS 97 (windows XP) between multi-
user in a serve-based environment.


Again,
Two users are adding a new data on the same form at the same time.
Second user can see data, which first user enters on the same form.
Later, user 1 can see corrupted data on the form. The form displays
#Deleted.
how can i handle this?


Please advise.

In Tools - Options under the Advanced tab set the Default Record Locking to Edited record. Then the record being worked on is locked by the first user and this will avoid the corruption.

Mary