Sunday, April 11, 2010

Preventing data loss due to file corruption

Today I got a call from one of my customers. He had problem in one particular area and was getting unspecified error. I told him to try following
Goto backup menu in VFAS. Click data repair buton at the bottom. It took almost 3 to 4 minutes to repair his data. Then I told him to click compact data button. It also took 3 to 4 minutes.
Then I told him to click green button of hard disk backup.
After this I told him to close the VFAS software and check size of his data file in vfas folder
c:\vfas\f1\ABCD0910.vfd and c:\vfas\f1\ABCD0910.bak to his surprise
the sizes were like this
c:\vfas\f1\ABCD0910.vfd 8 mb
c:\vfas\f1\ABCD0910.bak 500 mb
The software had done all the trick to reduce his data from 500 mb to 8 mb.
I recommend all my users to regularly click greeen hard disk backup button.
The advantages of small data size are as follows
  • It gives faster dataentry
  • It gives fater reporting
  • It reduces chances of data getting corrupt as it requires less time to close the data file when the programm closes. This is like boarding a train with a small family of 4 persons and large joint family of 40 persons. In a large family some member may not get to board the train before it leaves.