Hello,

I have a database application that uses data bound controls in VB5.0 SP2 to update data in a Visual FoxPro 6.0 database using an ODBCDirect connection. It works OK except I want to make sure that it works in a multi user environment. At them moment the data bound controls do not give any error when 2 users update the same information at the same time.

I want to be able to lock the current record so that only 1 user can update it a time. I have tried setting the Options property on the data bound control to a suitable value ( eg to 'dbSeeChanges' ) but I get an error when loading the form if the Option is anything other than zero. Also I have tried opening an ODBCDirect RecordSet over the database so that I could lock the current record manually, but I am unable to open a recordset for update ( only allows readonly ).

My question is:

Is there a way of opening an ODBCDirect RecordSet for update over a Visual FoxPro database ?
How can I implement record locking using Data Bound Controls and ODBCDirect, Visual FoxPro ?

Thanks,
Aengus O'Sullivan