Wai,

>Q1.
>it is not necessary to set exclusive .T. in multiuser environment?!!?

No, exclkysive use prevents any other user fomr opening the table for reading or writing. Exclusive use is definitely not for mulituser systems.

>Q2.
>refer your point 2, if i didn't use pack for delete record, how can VFP delete the marked record for me?!

Don't worry about the deleted record being there. SET DELETED ON and VFP will ingore the record. You can create an administrative operation maybe run once a week to pack all the tables if you need to do that. I don't ever pack, instead I recycle deleted records when I need to add a new record I first find a deleted one and recall it, otherwise, if there are no deleted records I add a new one.

>Q3.
>is any other method that can delete the record from the table, but will not cause the problem (something like disconnection....). and if i only set delete on for the record, will the record appear in an other user in another mechine?!

No, DELETE marks the record as deleted. SET DELETED ON causes VFP to ignore records that are marked deleted. The only ways to remove the records (deleted) is to either PACK the table or copy the non-deleted records to a new table, clear the old table, and copy the recors bacl again (which is what PACK does anyway).