>Try move change data after BEGIN TRANSACTION.
No, don't do this. This will lock records during this process.


>
> How have you version VFP and SP?
>
> MartinJ
>
>>Hi,
>>Yes.. before BEGIN TRANSACTION! I open all of these tables in table buffering mode.
>>
>>Any ideas?