>I have found that alter table command
>causes error:
>
>File c:\temp\0502743.tmp does not exist
>
>My program runs on NT 4.0 server and VFP 5 build 415 runtime.
>c:\temp is NT temporary files catalog. Workstations can use dbf files in server normally using same common exe file located in server.
>I can create and edit files in this temporary directory.
>Program works about year normally. Suddenly it starts to produce this error. This error occurs always when I try to open form. Other commands which create files in temporary directory work OK.
>Why?
>

c:\temp could be marked as a System folder.

I have this problem temporarily, where the Windows temp folder I assigned is not a System folder for a while, then suddenly one day it is. I have no idea why it suddenly is.

VFP ignores system folders. Cursors are created in memory but have a path assigned, but not necessarily disk presence.
When a DBF() (usu. w/ APPEND FROM DBF()...) or ALTER TABLE is fired on it, it tries to get it from disk. Since it ignores system folders, the file doesn't exist.

You can include a config.fpw file in your exe with a TMPFILES directive to a folder that is definitely not a system file - like a relative path to "myapplicationstempfolder".