Yes, I also agreed with your theory.

And after reading about REFRESH in Hacker's, I doubt that it would have much impact.

I'm guess that in the problem at hand, though, EXCL is not in effect. When all is said and done it looks like we will have yet another theory on our hands.

Cheers,

Jim N

>>Hi Bruce,
>>
>>I'm thinking this was your 'theory of lost data' or something like that that you are referring to. Is that correct?
>>
>>If so, I don't remember how you solved it.
>>
>>But in the context of this problem how would you rate this idea. . . SET REFRESH???
>
>Yes, that was my theory :) And I'm quite sure it's a true one. Sometimes, I think only with EXCL on, vfp will copy a table (if it fits) to the local machine, and perform all its work there, I think even including commands like FLUSH and SET REFRESH, and certainly TABLEUPDATE.
>
>My solution was to close and reopen the pertinent tables at specific points, particluarly after some statistical processing was done, there is no question that will push data to server. Also, I reopened SHARED where possible, since...
>
>I'm not positive about SHARED tables - but I'm inclined to think this will not occur in that more typical multi-user case, else we would have heard a lot more about it by now. My EXCL usage in a multi-user environment is a little unusual, and many of my tables are large enough so that they won't fit on a local machine anyway, another reason we haven't had this problem appear before...