I think that FLUSH, UNLOCK command will help.
Look also to SET REFRESH command. It controls the how often local data buffers are updated with current data from the network (in seconds)

>For a quick summary:
>What I'm trying to do is update a file on the sever via my VFP program (that hast VFP flat file(s) opened). Moving off the record and allowing another person's program (not a VFP program) running on a PC clients to see the changes via ODBC. Then they would process their part and update the same file with another flag. My program on the server loop through via a timer, and see what changes he made, so I can can do some additional processing.
>
>Issues:
>Not being able to see the changes if the file is still open in VFP. Neither of us can see each others changes unless I close and reopen the file. Not to efficient here!
>
>Would it be best for me to open the files as a ODBC view and update them using tableupdate()? Also, I would require some insight on this, since I'm not that familar in using ODBC.
>
>Any help would be greatly appreciated.
>
>Craig