Hey All

Making a multi user application running off one central DB SQL2k
Whats the best way to go about locking records when users read them, So that two records cant be shown to the same user allowing user 2 to override what user 1 done...

Any Comments

Using
vb.net, MSSQL2kse Stored Procs