This is multi user app. Now what i want when one user open record in edit/delete mode , other user should get the error msg the record is locked by other user. I have a table structure i.e
EmpMaster ---- Master Records of Employees -- Primary Key
EmpLog ---- Records Attendance of Employees -- Foreign Key
I want when 'A' user click on Edit/Delete Button , particular Record from the above tables should be locked on server. And When the 'B' User Want to delete/modify same record an error should be raised , but the user can view the record. How can i do this.
i am using Vb6 with Ado 2.7 and Sql Server 7.0.
i have heared the Row Level Locking Can also be done on Sql Server.