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