Hi Jim,
In the past few years I've only seen three causes of VFP data corruption personally.
1) bad shutdown (power outage and UPS battery failed)
2) bad network card or switch
3) write cache turned on for server hard drives
Guy
>Naomi --
>
>Both reasonable suggestions, which I will try ...
>
>Is what is going wrong here some failure when two people try to insert at the same time? No automatic file locking? (Just trying to understand the root cause).
>
>Thanks,
>
>Jim
>
>
>>>I have an event history file which evidently can get corrupted.
>>>
>>>The only time the file is written to is by this code
>>>
Select 0
>>>Use (fname) Alias EventHistory Shared
>>>
>>>Insert Into EventHistory (When, who, pgmname, exename, desc1, desc2) ;
>>> VALUES (MountainTime(),goVars.UserName, goVars.ApplicationName, Juststem(Sys(16,3));
>>> , lcText1, lcText2)
>>>Use
>>>
>>>
>>>Do I need to put some locking around this, and, if so, what would the code look like?
>>>
>>>Thanks