In MsAccess project I Create the Link table with Sqlserver 2000.

I am facing the multiuser Problem in my application. The problem describes below:

If one user is updating one record and at that same time another user
try to modify the same record. Now current application is allowing the second user to modify the same record.

Before going to update the record, I gave the select Query to Select the...