As I wrote in another message, we require that our users have a UPS on every PC, including the server and all routers/switches. If they don't have power backup, our contract says that they must pay roughly 100 euro per hour for the first fix, 200 for the second time, 400 for the third, 800 for the fourth, and so on. They will very soon get the picture.

But with the low prices for a UPS, and the extra security it gives, I rarely hear any complaints. On the contrary, our customers understand that we only have their interest in mind, and see us as very professional company.

>Hi Tore, thanks for replying.
>I must say I agree that that is a very impressive record.
>Our app is installed typically in sites that have a server , and perhaps 15 pc's
>In some sites, we never get a corruption, but in one speciifc site it has happened
> 2 times ober the last 3 weeks, and it is a critical site.
>In other sites , over the years , it happens infreqqiently, but seems to be neraly always
> as a result of a server or Pc going down.
>
>I suspect it maybe Power issues, but the customer is adamant that there are no problems with power.
>It could also be a faulty PC
>It could be a network problem
>It could also be my App ??(although unlikely)
>
>When it does happen, it just seems to be the Header on the DBC/DBF is the problem and no data ACTUALLY gets
> corrupted, but I have to run the repair utility manually anyway.
>
>What I am looking for is someway of running this repair automatically as in
>If BadTable('MYTABLE') && I already have BadTaBle working
> Repair(MyTable)
>Endif
>
>regards,
>Gerard
>
>
>
>
>
>>Yes, they have, but our system is well written so it has never caused any corruption. Never, period. If you don't believe me, then that's your problem.
>>
>>>So in 20 years not one of your users has ever misbehaved. Turned off the PC in the middle of you app doing something etc. Thats impressively weird.
>>>
>>>
>>>
>>>>Oh yes, daily. And it's a pretty advanced system. But we do take precaution, for instance all users must have his/her own UPS.
>>>>
>>>>>Maybe they aren't really using your system :-)
>>>>>
>>>>>>I would spend some time to find out WHY you get the corruption. My last corruption was nearly 20 years ago. Also my 2000+ users have never reported any corruption, not a single case!
>>>>>>
>>>>>>>I use DB Recovery do fix and repair corrupt datatbase (Usually the header only gets corrupt)
>>>>>>>
>>>>>>>I have a .prg whcih tells me of a dbf is corrup or not....anybody know if DB recovery (or something else) can be automated
>>>>>>> in a .prg to fix a table (If my Identify.prg returns that a table is corrupt)
>>>>>>>
>>>>>>>regards,
>>>>>>>Gerard