John,

You haven't said what goes on while the table is being "held hostage." If it's just some sort of report you could make a snapshot of the data by copying it. If you're doing multiple updates, wrap them in transactions.


>Hi.,
> I have couple of forms used for custom setting for supervisor. These forms only allowed to be run in ONE of the workstations in netowrk. Once these forms launched, nobody are allowed to update the table.
> In the situation above, is it good to use FLOCK to lock the table from form.INIT until the form released? Or, do you have any other suggestion?
>
>Thank you