I have found that due to things like network buffering and other issues that the Foxpro FLUSH command doesn't really work and that the only real way to lock data in after a write is to close the table and reopen it. Painful but I learned the hard way.

Pete