thanks sylvain,

How do I keep the current lock specific to a perticular user. Is there a unique connection # or something I could use so that only the one user that updates the field can reset the field even if the same user logs into SQL from another station with same id ?

Don