I have a simple multi-user VFP app (NT-4) where users can add, edit and delete records in a DBF. The DBF has an associated CDX. When I look at the files in Windows Explorer sometimes the CDX has a timestamp which is beyond that for the DBF. The app may be running at the time. It would seem to me that the only way this could happen is if the INDEX or REINDEX commands are run but this is not occurring in my case. Could the DBF and the CDX be out of sync or is it something about the way the OS interacts with VFP ? I have not been able to re-create this.

Along the same lines, why do you have to close a DBF before the timestamp is updated by the OS ? When you edit data on a record and move to another record, the changes are made to disk right away aren't they ??

I'm also using record buffering but that shouldn't matter since I'm committing changes right away.