In a multiuser environment, sometimes out of nowhere we will get "file not found" error when trying to USE a DBF on a central server. It is totally out of nowhere. All day it will work, and then randomly we will get "file not found".
I dont know if the two are related, but once the "file not found" error happends, all other clients trying to access that DBF file hang trying to USE the file because it is locked. The onlyway to solve the problem is to restart the server. I assume this is because when using EXCLUSIVE or NOUPDATE it creates a temp file or something. Any ideas on the "file not found" error and why the DBF doesnt get unlocked after our application crashes on the clients machine.
I dont know if the two are related, but once the "file not found" error happends, all other clients trying to access that DBF file hang trying to USE the file because it is locked. The onlyway to solve the problem is to restart the server. I assume this is because when using EXCLUSIVE or NOUPDATE it creates a temp file or something. Any ideas on the "file not found" error and why the DBF doesnt get unlocked after our application crashes on the clients machine.