Those issues are not because of Foxpro, but because default settings of network components
Settings like Oportunistic locking, File handles cache (RFCB), disk write cache can cause a lot of headaches.

See this discussion on Wiki
http://fox.wikis.com/wc.dll?Wiki~VFPTableConcurrency
Check also (Apps with shared acces)
http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html
http://www.capitaloffice.com.au/resources/windows_trouble.htm

Good luck.


>>How about explictly (a) issuing an UNLOCK command after creating new / updating records and (b) issuing a CLOSE DATABASE on program exit?
>Well, i will try that, just noticed i run CLOSE ALL, CLEAR ALL, CLEAR DLLS and CLEAR PROGRAM, but no explicit CLOSE DATABASE...
>I'll try also the unlock to see if it helps...
>Thank you for your suggestion
>Jaime
>
>>
>>HTH
>>
>>
>>>VFP6 app in one site and VFP7 app in the other...Also, i can compile the VFP6 app to vFP7 if necessary
>>>Jaime
>>>
>>>>Jaime, what version of VFP are you using?
>>>>
>>>>
>>>>>Hi All
>>>>>I have a problem that is happening in a random manner in two different sites.
>>>>>The problem in both sites started to happen when they installed Win2K server and added some workstations to the system. Both sites now run with 15-20 workstations.
>>>>>The programs in question just use the old APPEND BLANK then REPLACE to save data. The problem is that sometimes the program gets "File Access Denied" errors when trying to open some tables ( even for reading! ), and in some cases, some data is lost inconsistently in some tables.
>>>>>When checking open files in the server, i see all tables opened, even if the workstation already closed the program...I even checked doing DOS copy command on a bunch of tables from the server, and i see that even when closing the DOS window, some tables remain opened in the server.
>>>>>All the hardware experts in both sites claim ( of course ) the problem is in the software, but the only difference i see is they have more traffic with more workstations.
>>>>>In other sites, i have also some FOXPRO25 applications that run with a heavy activity from 50 workstations simultaneously, without any glitch whatsoever ( although those run on Novell Servers ).
>>>>>I think there is either some problem with the definition of the Win2K server, or some hardware problem ( Switch or some NIC ), but i am starting to think i should change the way my VFP app opens or saves the tables...
>>>>>Any ideas?
>>>>>Jaime