>We went through some rather vigorous muti-user testing today. We had one major issue :
>
>Error #108. File is in use by another user.
>
>What seems to happen is when user A appends blank and begins to fill out the data fields on the form user B,C,D... cannot append blank until user A has saved. =cursorsetprop("Buffering", 4, "Training") is set on the file. Is this normal for VFP ? Can't be. What am I doing wrong.
>
>Any help would be much appreciated
>
>Thanks
>
>
>Scott
Scott,
This is a major weakness with pessimistic buffering. VFP is trying to guarantee that it can save your new record when you say so, in order to do that it must hold a lock on teh dbf header. This prevents anyone else from getting a lock on the header. Changing to optimistic buffering will eliminate this problem.