Memo fields on dbf/fpt file

[coned]

I've discovered some corrupted data in some of the memo fields on one of our .dbf files. I used access to update the value in the corrupted fields to null - just to get rid of the corruption. This has caused more trouble than it was worth. It seems that the actual data in memo fields is stored in the related .fpt file and that fpt file is now either missing or invalid. It's not actually missing - I can see it but when I pack and reindex that .dbf it throws the missing or invalid error. What can I do? Can I run a repair utility? Is there one available that's been successful at repairing these types of problems?
This is causing other reports and programs not to be able to run on our system.
thanks.

 

[jesylv]

If I understand correctly you have used ACCESS to replace the memo pointer in the DBF by a .NULL. value. In doing so you basically broke the link between your DBF records and the corresponding memo data. Your only hope is to restore memo pointers from a backup copy.

Good luck

Jean

 

[coned]

I have backups - how would I go about restoring the memo pointers?

 

[jesylv]

Also take a look at this thread:


thread184-625696

 

[jesylv]

Try this:
Restore your DBF,FPT and CDX (if there is one) in a directory. Assuming MyKey is your Primary key

USE C:\MyData\MyFile IN 0 EXCLUSIVE
USE C:\MyBackUp\Myfile IN 0 EXCLUSIVE ALIAS MyBackUp
SELECT MyFile
REPLACE MyFile.MyMemo WITH MyBackUp.MyMemo FOR MyFile.MyKey = MyBackUp.MyKey
use in MyBackUp

Good Luck

 

[keepingbusy]

Hi coned

If you haven't already resolved your problem, go here:

http://customsoftwareapplications.co.uk/csoftware/download.htm

Good luck

KB

When everything else is said and done, there will be nothing else to say or do