Modifying Rows in a DB

[Bipasha]

Could anyone help me implement this??

When one user is modifying a row in a DB - no other user should be allowed to modify that row of the DB??

 

[Rydel]

As an ASP developer you don't have worry about this, since SQL Server itself is responsible for locking the records. ---

http://www.geocities.com/rydel23/

---

 

[asptim]

Make sure you are using the correct type of cursor and lock within your recordset! That should help.> Actually I think there are about 4 methods of doing so in ADO, but in ASP only 2 really count.. Basically, you are using ADO to lock the database until your update is complete.. Like the other person said though, SQL server will manage this for you I do believe.. You might however have to have the updates in order of time updated, and if so, I think you'll have to do this with your ADO lock type to accomplish what you're after..
Hope that is clear..
Tim