>Just built a new application with VFP8 and went live Monday. I have gotten a few "File in use by another user" error messages. I use views and cursors exclusively and the I only time I go against the dbc and table is when I do an insert or a sql statement. There are twenty users key very hard against the main files. I have used the default value for set reprocess. It appears I will have to use a higher value for set reprocess. What are the downfalls if any for a higher value in set reprocess or if you have any suggestions in how to prevent the errors would be greatly appreciate it. Should I consider setting reprocess to automatic. The help files gives some alternatives but I was looking for some real world experiences or best practices.
>
Gaylen,
What VFP command did you get this error on? USE, INSERT or some other?
--sb--