Jump to content


Photo

Corrupted DBF file


  • Please log in to reply
3 replies to this topic

#1 murius53

murius53

    Serf

  • Lurker
  • 1 posts

Posted 22 October 2015 - 10:01 PM

I have a problem where dbf files will show an incredibly large (not to mention completely impossible) size.  Currently, the size reported if I do a listing is over 3 gig.  This is obviously wrong since it is stored on a 1gig drive.  Any ideas why this is happening or how to fix it?



#2 Rybags

Rybags

    Immortal

  • Super Hero
  • 34,840 posts

Posted 22 October 2015 - 10:22 PM

Use a bigger drive.  1 Gig is miniscule, even for a flashdrive.

 

If that doesn't work, then just wait for the guy that'll show up in a couple of hours with a shiny new account and post links to the DataNumen or RepairToolbox websites, and probably using a different font for his posts than most of us use.



#3 muhaajirhares

muhaajirhares

    Serf

  • Lurker
  • 1 posts

Posted 30 October 2015 - 06:17 AM

You may use guide below...

 

OR topics which were collected from Internet space

 

http://www.sqlteam.c...TOPIC_ID=197008

http://www.idganswer...support-library

 

Ultimate solution is directed to severe corruption in .dbf files https://onlinefilere...air-online.html

 

It is not necessary to rebuild a corrupt database. All corrupt databases can fixed in less than one minute. 

The solution is :

Open database to main screen

Copy the database but only one record(just pick a not recent record number at random; include "all", I usually name this database "FixMMDD" (( month Day))

Open original database to mainscreen and append the FIXMMDD.dbf.

You're done. 

Occassionally you may have to update indexes. Very rarely are any records lost and when it happens those few records are clearly garbled.

I've been doing this for three years with no problems.

If you have fields that increment you'll have to adjust that for your last valid value.



#4 Rybags

Rybags

    Immortal

  • Super Hero
  • 34,840 posts

Posted 30 October 2015 - 09:14 AM

What should I do about my pesky butt-hair that pokes out the bottom of my Daisy Dukes?


Edited by Rybags, 30 October 2015 - 09:38 AM.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users