>If the table is exclusive client can delete the files
> but can not work in network
>
> If the table is not exclusive client can work in network
> but can't delete the records
>
> What's the best solution for this problem
Moises,
User can delete records in a multi-user environment. A lock is issued on the specified record and it is marked for deletion. If you issue a SET DELETED ON in your application, VFP filters out the deleted records.
Now if you want to pack your tables to really get rid of the records, you have an issue. However, most of the time, I have found you don't need to do this while users are in. You can set up a timer and do this kind of stuff in the off hours.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao