> -----Original Message-----
> this is how i write my connectionstring in VB

OOI, what transaction type are you using? Not sure if it makes a difference
when using the WITH LOCK option.

Alternatively, you could create a stored proc which updates a record if it
exists, otherwise inserts the record. That way if another user deletes the
record it will be re-inserted.

Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://sourceforge.net/projects/dnfBB - Web based, Firebird Powered Forum