IzabellaMendenhall Posted September 10, 2017 Share Posted September 10, 2017 All my databases except one are in backup storage. One database, which I use every day, I forgot to send in backup. Today it has stopped opening via FoxPro. I've appealed to help to our tech specialists, but they can't help me, because of theirs vacations. Probably, someone's here could? Link to comment Share on other sites More sharing options...
straycat19 Posted September 10, 2017 Share Posted September 10, 2017 Have you tried googling your probelm? There are a lot of possible solutions but you can only find the one that will fix your problem by trying them. Check the solution on this website. https://community.spiceworks.com/topic/1396455-how-to-fix-corrupted-visual-foxpro-9-dbf-dbc Link to comment Share on other sites More sharing options...
FintanO'Ryan Posted September 10, 2017 Share Posted September 10, 2017 In case nothing of mentioned below isn’t effective for you, then take a look at dbf recover Here is the great choice of variants for solving - http://fox.wikis.com/wc.dll?Wiki~TableCorruptionRepairTools Article as alternative variant of solution: https://support.microsoft.com/en-us/help/193952/how-to-troubleshoot-to-resolve-suspected-corruption-in-visual-foxpro If you have access to Visual FoxPro command line window, type: SET TABLEVALIDATE 11 USE "YourTable" EXCLUSIVE && If the table is damaged VFP must display an error here PACK && To reindex the table and deleted "marked" records PACK MEMO && If you have memo fields After doing that, the structure of the table must ve valid, if you want to see fields with invalid data, you can try: SELECT * FROM YourTable WHERE EMPTY(YourField) && All records with YourField empty SELECT * FROM YourTable WHERE LEN(YourMemoField) > 200 && All records with a long memo field, there can be corrupted data Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.