Memo file invalid/missing - urgent!

[DarrenWard]

I am getting the following message when I try and pack a table.

I can open the table, brows it and even call up the memo data for individual records, but can not reindex or pack the table.

I have run FoxFix 5 on the table and it reports invalid pointers, but when I update! it doesnt clear the problem.

The table is one of our sales ledger tables, and the error is crashing the month end proceedures in out accounts package, any help would be greatly appreciated.

Darren

GuiltyMaggot - The best rock band in the world!

 

[DarrenWard]

Its ok, I have solved the problem, literally as I was posting the original message.

I took a copy of the table, emptied all the memo fields in the original table and wrote a short piece of code to copy the memo fields back one by one.

Darren

GuiltyMaggot - The best rock band in the world!