I have created some software where multiple users need to access the data at the same time and make changes to the same table. I have all the files open shared so that multiple people can use see the data at the same time, but if someone tries to write to the file by modifying a record or adding a new record the the file, the error File is in Use by Another User will come up every once in a while. It does not happen always. But I thought that if the files were open shared, that this was not supposed to happen.
I am using VFP 6.0 and the data and software is on a windows 2000 server environment. It seems like this happens when there are a lot of people on it and making changes at the same time. Am I missing something here? Please help.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.