Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Restore information from fpt file
Message
 
 
À
01/09/2020 12:42:28
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01675939
Message ID:
01675950
Vues:
51
>>Something strange happend: I opened a table over the network (vpn) exclusive, did some changes, issue a pack, and an error message "Table does not exist" appeared. Closed VFP, and the DBF file was gone from the server location. No other user was logged into the server at that time. The fpt and cdx files are both still there.
>>
>>I can re-create the records from the dbf from another table that has the contains the same records but without any memo fields. So I was thinking is there a way to pull out information from the fpt file and try to match those with the records from the other dbf to re-create some of that data?
>
>It's difficult. But, FPT files store data by block size, so the data can be scanned on those block sizes and extracted. The issue will be you'll find some records that are no longer in use but appear valid, records will be out of order. But if you're interested, you can extract the data in the FTP records and then manually reassemble them afterward.
>
>BTW, it may have been anti-virus that deleted the file. Find out if it's quarantined somewhere and maybe you can get it back.

I checked locally defender quarantine already, but nothing. Not sure if av on the server would quarantine the file.

I never deleted records in this table, so if matches can be done with recno, it may work. I always created a table excluding the memo info, but this dbf is basically identical to the original Dbf, except the missing memo columns. So it may be worth the try.
Christian Isberner
Software Consultant
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform