>>Unrelated to your problem, I would recomend to SET TABLEVALIDATE to 7. It'll prevent "file in use" error on a table open.
>Where did 7 come from? it applies to VFP 8? If so, it would be great. Because my app logs errors occured at runtime, I've alot entries of "file in use".
The flag 4 came with VFP8 SP1 and documented in its Readme:
http://download.microsoft.com/download/2/f/6/2f6db93f-c0e7-4cf3-82bf-cec0ecef5c84/SP1Readme.htm4 - Suppress "File is in use (Error 3)" if table header cannot be locked when opening the table. Requires setting the first bit to validate record count when opening a table.
There's also flag 8 but you shouldn't use it. See
Re: SERIOUS BUG in SET TABLEVALIDATE !!!!!!! Message #
990598 for details.
--sb--