>Craig,
> When we reindex files the indexes are deleted and then rebuilt. In the past we would only reindex when needed (when seeks started to get slow). But when we were forced to reindex the Foxpro system would be shut down for an hour or two, which meant everyone in the company sat. So we decided to do it on off hours on the weekend.
> As far as file corruptions we run Foxfix once or twice a year to fix a damaged dbf. Whether or not Foxfix fixes all corruption errors I'm not sure.
>
>David Thome
OK. Probably not data corruption then and you're doing the right thing to build the indexes. Another thought just came to mind. When VFP terminates abnormally, it leaves temp files around. Are you cleaning these up? My experience shows that these temp files sitting around can cause more problems.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer