RE: Damaged DBF's

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Thomas Jacob (anonymous_at_discussions.microsoft.com)
Date: 02/24/04 

Date: Tue, 24 Feb 2004 05:56:07 -0800

Hi Paul,

Let me tell you what we were doing when a dbf got corrupted. Our tables were in Dos Foxpro. We use to open the tables in (mFoxplus) add a record in it and save it.

I think you have to update the table header by opening it in low level. Calculate the table size (record length * no. of records). This information you can put in the header. Try coping this table to some other name and do these things.

Thomas Jacob

Relevant Pages

  • Re: Strange VFP 9 behavior
    ... But that isn't going to happen since VFP 9 is VFP Last as we all know. ... much better at DBF tables and indexes. ... that it's possible incorrect reccount in DBF header that the initial corruption for more serious ones? ... Validate record count when opening a table. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: repair corrupt free standing table
    ... Try FoxFix from Hallogram.Com. ... The header is variable length. ... can load the DBF, strip off the header, and save the results to a text ... file format is such a bullet-proof style. ...
    (microsoft.public.fox.vfp.dbc)
  • Re: File Size Discrepancies
    ... compare HEADERwith the filesize of a newly created ... empty DBF, which consists of the header only. ... So the +1 is the byte between header and the first record, ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Visual Foxpro Dateien per DTS importieren
    ... Wenn das dann immer noch nicht hilft, dann fehlt wahrscheinlich im DBF Header der Eintrag mit welcher Codepage die DBF "gefüllt" wurde. ... Wenn Du ein FoxPro zur Verfügung hast, und die DBF öffnest, dann frägt FoxPro nach der Codepage. ... Normalerweise sollte aus dem Header in der Datei der Zeichensatz ...
    (microsoft.public.de.sqlserver)
  • Re: Fehlermeldung : "keine Tabelle" Tabelle > 2 GByte
    ... und das hab ich eben auch nochmal geprüft. ... Erstellt man eine DBF, dann ist Header() exakt ... die DBF-Dateigröße, die Formel ...
    (microsoft.public.de.fox)