Locking records

[Tonatiuh]

My app access to a FoxPro database into a Novell Netware 5.0 file server. When two users open and try to update the same recordset, I get an error:

Run-time error '-2147467259 (80004005)':
Query based update failed. The row to update could not be found.

How can I avoid my app of this problem? How can I lock the recods updating and how another client that try to update the same records can know that are locked an wait for the updating (in the another client) ends? Or desists of updating?

I'm using VB6 and ADO 2.1. My App runs in Win 9x/NT use a DSN ODBC to connect to database.

Any idea will be deeply appreciated.

[bbUFO]

How about put a field in table as status. When user A updates the record, makes the status as 'Updating'. User B wait for this Updating status gone.