A bigger UPS should take care of all of that. Could there be static electricity too?
Sometimes a coffee pot, an air conditioner, or copier is on the same line and that causes problems intermittently. Make sure all the write caching is turned off. Make sure all files are closed when not in use. Another thing you can do in your program is open the file once it's downloaded. If it returns an error, re-download it. --- On Sat, 8/15/09, John Weller <[email protected]> wrote: > From: John Weller <[email protected]> > Subject: Power Supplies and Data Corruption > To: [email protected] > Date: Saturday, August 15, 2009, 7:48 AM > I have a client using a couple of > apps written in VFP9 using a common native > VFP back end. One of the apps is used for an hour or > so most days and the > other opens every 5 minutes 24/7 and checks for data to > download then > downloads and imports it. Every few weeks or so (not > regular) they call me > with a corrupt table. Their offices are in a former > factory which has been > converted to industrial and retail units. I think the > corruption is caused > by a power spike when the tables are open. Assuming > that this is the case I > have recommended that they install better power smoothing > equipment than > they already have or gat the apps re-written to use a more > robust data > storage system. Bothe these solutions are outside my > experience - any > suggestions gratefully received <g>. > > TIA > > John Weller > 01380 723235 > 07976 393631 > > > > _______________________________________________ > Post Messages to: [email protected] > Subscription Maintenance: http://leafe.com/mailman/listinfo/profox > OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech > Searchable Archive: http://leafe.com/archives/search/profox > This message: > http://leafe.com/archives/byMID/profox/1b407e223d4b4ba5aee36442f1977...@wessex1 > ** All postings, unless explicitly stated otherwise, are > the opinions of the author, and do not constitute legal or > medical advice. This statement is added to the messages for > those lawyers who are too stupid to see the obvious. > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
