Hello Al,

I have been doing a lot of research on this problem and may have narrowed it to some phenomenon known as Opportunistic Locking (oplock). See Q296264. These are machine settings, rather than software actions.

So, in my particular situation, my main screen has a BufferMode setting of 2, which is called "Optimistic Locking" in the VFP Documentation. The table has a BufferModeOverride setting of 1, which defaults the setting to the one shown on the form.

The question is do these two factors relate to each other, and to the problem of my disappearing records? Should I change the BufferMode in the form to Pessimistic, or should I go into the server and workstations to change the machine settings? Or should I change them both?

Any light you could shed on this would be greatly appreciated.

Thanks for your help.

Howard Shachter