You should probably consider segmenting your data in smaller tables (e.g. each 2000 records in a separate table.) Perhaps you can archive old records in separate tables to reduce the size of the "production" tables. A solution like this is very application specific but it might work for you.
>Everyone,
>
>I just hit the 2GB limit on an .FPT file resulting in 'space exceeded' type error (forget exact message). The associated .DBF is 724KB.
>
>Reviewing the thread below reveals serious debate among industry heavyweights regarding the 2gb limit but I couldnt glean a final answer.
>
>
http://www.levelextreme.com/wconnect/wc.dll?FournierTransformation~?2,15,520675>
>VFP 7 Help under "Memo Field Type" states "Memo fields are limited only by the amount of available disk space."
>
>So, a final yes/no/workaround regarding this limitation would be greatly appreciated...
Hector Correa