Hi,

I have a project for a money transfer compnay in VB6 and MS SQL 2000 and there are more than 20 Users working on the same project
In one of my table there is a record to be updated by all users.

I am using the following code

"update LCStockMS set Month2 = " & StAmt & " where On_Year = '2007' AND C_Code = 'EBL' "


Where StAmt is the amount to be settled to the currespondent on each transactions

But I got wrong value when multiple users doing at a same time.

So any body can suggest a solution to clear this problem

With regards,
Nasreen