Yes. Turn it off. If I'm not mistaken, you can then operate as in the old FoxPro where an update and a FLUSH will update your record immediately in the physical table.

How are you updating? Are you doing a REPLACE ALL, REPLACE or SQL UPDATE?

Dave