You all are right but why the same application has no problem when it running on users workstations (20 workstations at the same time) and connecting to the same database files? Zygmunt Cwalinski Systems Analyst, Citrix and Terminal Services Network Services, Infrastructure Support, IT Metroland Media Group Ltd. e-mail: ZCwalinski@xxxxxxxxxxxxx <mailto:ZCwalinski@xxxxxxxxxxxxx> ________________________________ From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Steve Greenberg Sent: 11-09-2007 12:42 PM To: thin@xxxxxxxxxxxxx Subject: [THIN] Re: Locked files in FoxPro published applications I think I should frame this post and send it to Jim K. ! Steve Greenberg Thin Client Computing 34522 N. Scottsdale Rd D8453 Scottsdale, AZ 85262 (602) 432-8649 www.thinclient.net steveg@xxxxxxxxxxxxxx ________________________________ From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Andrew Wood Sent: Tuesday, September 11, 2007 9:22 AM To: thin@xxxxxxxxxxxxx Subject: [THIN] Re: Locked files in FoxPro published applications And then you call Citrix and they say its a Microsoft problem... And then you realise you simply should've asked this list ;) From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Steve Greenberg Sent: 11 September 2007 17:29 To: thin@xxxxxxxxxxxxx Subject: [THIN] Re: Locked files in FoxPro published applications But if you talk to the OS people they will say it is a hardware problem and then when you show them clearly how it is none of those they all say it is a Citrix problem! :-) Steve Greenberg Thin Client Computing 34522 N. Scottsdale Rd D8453 Scottsdale, AZ 85262 (602) 432-8649 www.thinclient.net steveg@xxxxxxxxxxxxxx ________________________________ From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Andrew Wood Sent: Tuesday, September 11, 2007 8:53 AM To: thin@xxxxxxxxxxxxx Subject: [THIN] Re: Locked files in FoxPro published applications Its not because the developers have forgotten to open a database/table in shared mode is it? Or that when they've implemented a lock for an update they've used a database lock rather than a record lock Because of course, app developers *never* get it wrong, its always the OS' fault. From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Cwalinski, Zygmunt Sent: 11 September 2007 14:56 To: thin@xxxxxxxxxxxxx Subject: [THIN] Locked files in FoxPro published applications We have a strange issue with a FoxPro application. From time to time some DBF files are locked and from FileMon I can see "Sharing Violation" error. Developers says that there is no error in the application and that it works when it run on users' PCs. It's just enough to log off all application's users and everything works again normally for a while (sometimes an hour, sometimes a day) I have come across Microsoft article http://support.microsoft.com/kb/818528/ <http://support.microsoft.com/kb/818528/> were it is suggested to change Windows behavior to maintain the data structures per users instead of per computer but I'm not sure if it helps as we don't have such a problem with any other application. I don't want to change the setting yet because I don't want to screw up other published applications on our servers. Server configuration: Citrix Metaframe XP, Windows 2000 SP4 Do you have any idea? Zygmunt Cwalinski Systems Analyst, Citrix and Terminal Services Network Services, Infrastructure Support, IT Metroland Media Group Ltd. e-mail: ZCwalinski@xxxxxxxxxxxxx <mailto:ZCwalinski@xxxxxxxxxxxxx>