Hi Frnds,

I need your help regarding my project that is an application software (ASP.NET and MS SQL Server 2000). I am describing my project here.

Say, I have A & B machine in my office. Both users will receive data from the database, which will generate in such a way so that if a user (A) processing a data at a particular time, another user (B) will not receive that data at that time rather s/he will process the next data.

Can anyone help me regarding this problem’s solution?

Thanks in advance.

This is not a "problem"....it is an event that has occured since the beginning of databases in the early 1970's. Databases would always, depending on who got the record first, the other user would be locked out until the record was released. With the emphasis now on substantial evidence, authorization, due to erroneous financial reporting and the fall of companies like Enron, Tyco, applications are now required to track changes, be it record or application. With that being said, to aide in analysis and/or audits, I suggest to avoid "record collision", divide the transactions according to some category,by region, state,transaction type,etc, then assign that category to a user.

Hope this helps.