>>this old thread I apperently have overlooked back then was mentioned recently. If you haven't already moved to SQL
>>or partioned tables, another (perhaps short term) solution might be to distribute the memo text more equally into dbf and fpt.
>>Could extend the room possible for your memo text by perhaps 20% to 40%.
>
>Could you elaborate more on this?

Could you post the result of

*-- Updated/not totally awake on first version...
select ;
      cast( IIF(Len(Alltrim(MemoFld))/50>30, 30, ;
		Len(Alltrim(MemoFld))/50 )  as I) as LenMemo ;
    , count(*) as CntMemo ;
    from Table ;
    group by 1

as well as the current dbf/fpt sizes and reccount() to get better estimate of the numbers involved ?

regards

thomas