ADO & SQL - Update & Messages

[vwiley1]

I have written a lot of application that use bound controls against ADO level data controls, recordsets, data environments, etc., but the problem arises when there are multiple users editting data and posting changes at the same time. ADO will report back that an update cannot be performed, but that is an still just an error code or response. My question is is there a way that messaging from
SQL server can broadcast or inform a VB app or data control that the underlying data has changed and that a refresh is required (like the eploreer window or simplier common dialogs)? Is there a way to use the old SENDMESSAGE API level calls to keep the app aware of SQL changes instead of either re-polling the data or refreshing contantly?

Vince

[svskumar]

Instead of that why dont u lock the records which u r editing