>>>
>>>What can I do to prevent this type of a problem from occurring?
>>
>>Add a lot of FLUSH commands!
>
>I looked at my code and see that FLUSH command has been there since 2002. So it must be something else.

How do you save data? Are you using buffered tables or views? Can you replicate this problem on your PC (make sure to not have anything important open <g>))