>
>>Also check SET TABLEVALIDATE. You wouldn't want to use default setting 3 in multiuser environment.
>>You may also SET TABLEPROMPT OFF.
>
>Thanks I have checked out the help file. I found the level setting in TABLEVALIDATE a bit complicated and there is no example, how can the bit for level be set? How is the actual command written?

Pick bit values that suit you and specify them in the command. For example

* 1 - Validate record count when opening a table.
* 2 - Validate record count when appending or inserting records and writing them to disk.
* 4 - Suppress "File is in use (Error 3)" 
 
SET TABLEVALIDATE TO 7
* or
SET TABLEVALIDATE TO 1+2+4