Our client are in the process of upgrading all servers' hardware and OS from 2000-2003 server. These servers have Citrix on them and are also being upgraded from XP Metaframe to Citrix 4. Although, the problems really started happening when they started the server upgrades last Saturday. The VFP application in question runs as a pseudo-service on each server during bootup.

>What is the mix of OSes for the file server and workstations?
>
>I seem to remember some locking incompatibility of the server is XP and workstations are lesser. I wonder if this could be similar?
>
>good luck
>
>>I think its sad that I have to enclose APPEND BLANK or INSERT in a TRY/CATCH block. I just had 2 of the 5 yearly occurences happened in the past 2 nights. I am looking forward to it happening again tonight when most of the processes will run. Incidentally, these recent occurences coincided with a hardware and OS (2000-2003) upgrades.
>>
>>I've always had faith in VFP to manage INSERTs for me. I guess, this isn't going to be the case anymore...
>>
>>>No. It locks header as well because the row count has to be updated.
>>>
>>>>Thank you for the feedback. Question, will using APPEND BLANK instead fix this?
>>>>
>>>>>The INSERT INTO command briefly locks the table header. If 2 inserts happen at the same time, you'll get error 108. Also some commands, like DELETE FOR/WHILE, REPLACE FOR/WHILE look the table whick could cause a similar result.
>>>>>
>>>>>>