>Hi guys..
>Need help in program with multiuser environment...
>Which is the best using buffering or not... If using buffering what's the different between buffer 5 with 3.....
>Cause i oftenly got confused using it... There's always a wait windows "attempting to lock..... esc to cancel"..... quite a long, maybe about 1 minutes... hence only me use the program, when i click save button.....
>
>
>help me out here...
>thanks...
>
>regards,
>tut_arie

Use Optimistic Table buffering. Row buffering causes automatic updates when the record pointer is moved, table buffering gives the developer complete control: updates are not made until a TABLEUPDATE() is issued.

Check the docs for the options available when using TABLEUPDATE, and also check the docs for SET REPROCESS.