>>Sounds like classic data corruption problems. I suggest a good data recovery tool to fix the problem.
>
>I agree, but how do I prevent it from getting corrupted again?
>
>I have many other applications that I have never had this problem with. The applications that I am having the problem with are all variations of the same product. It seems like I have done something different in these applications, but I have no idea what.


There is no way you can totally prohibit data corruption. It can happen with any application. There is a document on my web site that discusses data corruption. It isn't all inclusive, but may give you some ideas.