Hi,
Sorry, I misread what you were trying to do.
Have you tried packing the memo file, there can be a lot of bloat at times.
What type of data are you storing in the memo, if it is just text do what we did & simulate the memo into a DBF, much more stable.
If pictures etc store it in a directory with the year/month as the directory name and have pointer in the dbf pointing to the file, you could store 100Gig in the directory structure without any problems.
The design/structure of FPT files leaves a lot to be desired, block overwrite can be quite common.
>>Not correct, the DBF & FPT individually have a 2Gig limit i.e. total 4Gig between them, as for the CDX I would have to check, but I think it also has an individual limit of 2Gig.
>
>What I meant is that since the FTP will reach that limit first, and years before the DBF and CDX, I only have to worry about this one for now. My approach was to remove that field from the DBF in order to not be bound to that restriction. Then, I could have about 1 Gig in each of the FieldMemoX.dbf table which would hold the memo field values of all the records of Table.dbf.
Regards N Mc Donald