How would you determine if there are data that are missing? Do you have sequential key? Also, you should use a conditional TableUpdate if it is successful or not. This method is very important in a network environment because of table locks which are common in a multi-user system.

BEGIN TRANS
IF TABLEUPDATE(.T.,'yourtable')
    END TRANS
ELSE
    ROLLBACK
ENDIF 

>my program is store at Novell Lan Server, all workstations are
>access f:\MYSYS\OAMAIN.FXP to run it.
>
>i open all database in "Buffering", 5 mode.
>**********
>SELE 1
>USE OABUYER ORDER 1 ALIAS BUYER
>=CURSORSETPROP("BUFFERING",5)
>**********
>Q1. Sometime my client told me some of data had lost.
> but i had check the system many time. the code is
> correct to store the data while the use click "SAVE" button.
>
>Q2. is it everytime access "=TABLEUPDATE" & "=TABLEREVERT",
> we need to run "FLUSE" to force the system to store
> into basedata then do next line.
>
>Q3. sometime i open the OABUYER file in normal mode,
> for my checking data. BUT another users are open it
> at "BUFFERING,5". i will append or delete some records.
> is it the reason for missing record as Q1.