That's the better solution I've found so far. But I think you're missing something that I also recommend besides that: a good operating system. Our company has been asking everyone lately to forget about Win/95-98 machines and upgrade to Win 2000/XP Pro. That had save us from a lot of headaches specially in a country like this where the power supply is not the best.
Enmanuel
>
>How to avoid index file corrupt ??>
>Rebuilding an index on Init() is not a good solution. It is overkill and slow (what if you have many tags in a big table with lots of records)?
>
>The answer is a UPS in every workstation and at the server. Good quality LAN hardware (NICs, cabling, etc.)
>
>Good training to the users, to properly close files and logout before going home.
>And periodic maintenance (index rebuilding) doesn't hurt either.
>
>I follow these precepts and rarely have an index problem.
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain