Are you using pessimistic buffering on the source tables? If you are using views, do not buffer the source tables and do not open the source tables yourself. Only put the views in the form DE, and let VFP auto-open whatever tables it needs to open. Change the default buffering of the form to none or optimistic. In fact, I recommend setting the default buffering property of your base form class to none.

>I have a form called stock enquiry (form1), I use it to enquiry all the stock code that i needed, then double enter another form (form2) will be displayed, then all the related stock item will be displayed in the grid in the form2, (i append to the mycursor) when i click on the grid, it will display
>the related info to the textbox... (in the aftercolrowchange. method code ---> select myCursor
> go recno()
> stor descr to thisform.txtdescr.value
> stor balance to thisform.txtbal.value
> stor uprice to thisform.txtuprice.value
>
>It work ok when 1 person use... but come to multi user and enquiry the same stockcode, it will show "attemp to lock ......."
>
>Is the cursor is the local memory ? Coding will be appreciated....