hello, just wanna inform you that i've solved the bug, the problem seems to lie in the table i've created in SQL Server and not in my application as contrast to what i thaought earlier. I've tried editing or deleting the records there manually and i get the same error ("Too many rows have been afftected by update"), so i deleted the table and recreated the whole thing, i still don't know why this error occurs in SQL however, Maybe someone can enlighten me with this problem sometime. I'm happy to say that as of now i can edit and delete the records freely from my application. thanks for your help! really appreciated it. Good day