It's probably in the application. SQL Server doesn't do this type of checking. If you what to update something, it'll let you do it unless the resource is lock by another connection (not what you're seeing IMO).

-Mike