>>Thanks, Aleksey. In other words we need to use this setting for TABLEVALIDATE in our application if we want to be able to open the files.
>>
>Yes, you need to combine 4 with whatever setting you are using now, SET TABLEVALIDATE TO 4 will disable all validations and is equivalent to SET TABLEVALIDATE TO 0 in that sense.

I think we're using VFP default now.
>
>
>>The records still may be locked, right? But only the records that were updated, not all the records in the file. Am I right here?
>>
>VFP may choose to lock the file rather than locking individual records, it all depends.
>

Depends on what? We're inserting new records into several tables.