Is your form set to Private Data Session?

>I would like to ask opinion from the VFP users community, how good is VFP? I constantly have problems, while I just using standard code.
>
>All my code are like this:
>
>

>BEGIN TRANSACTION
>
>SELECT tableA           && all tables with buffermode=5
>   REPLACE ...
>INSERT INTO tableB ...
>
>ltableUpdate=.n.
>SELECT tableA
>IF TABLEUPDATE(.t.)
>   SELECT tableB
>      IF TABLEUPDATE(.t.)
>	ltableUpdate=.y.
>      ENDIF
>ENDIF
>
>IF ltableUpdate
>    END TRANSACTION
>ELSE
>    ROLLBACK
>ENDIF
>

>
>The app only good in stand alone, if running in multi-user environment, I constantly got 'File is in use by another user', rollback, missing records.
>
>I'm using VFP9, dbf, XP. no power failure problem.
>
>I think I have lost confidence in VFP
>
>any comment please.