concurrency control in my java application

[sfaisalawan]

Hi All

I have question on Record Lock in Java.

I have this Situation.
In my java application, a user can login and search all the (some product )cases which are open.
He opens up this case, see the details and click on EDIT button to edit the case.

At the same time another user logins and tries to edit or delete.
Then a message should pop up saying, the record is locked.

How do i lock the record for one particular user, and unlock after he is done updating ?


Thanks

Faisal

 

[MarvinM]

Hi Faisal,

Is this an Access issue or a Java issue?
If you want Java experts, try here: http://java.ittoolbox.com/

If you are talking about an Access issue and you merely access the Access form with Java, maybe it would be better to leave the Java out of the question.

It sounds like your real issue is with "concurrency". If you do a search on that term, you will find some good discussions of the topic here in this forum.

Regards,
Marvin M