>>1. A table file size is limited to 2Gb for all version of foxpro including VFP7.
>>2. The workaround is to split big tables horizontally or vertically.
>
>Thanks for the input Sergey,
>. Forgive my ignorance, but could you tell me how a file is split (how to resource)?
>Does this mean that an app that I create can access the entire file across several tables?
>
>Pete
It's hard to give you advice w/o knowing what kind of data you have in big tables.
In general, a vertical split means that you split fields from original big table
between two ore more tables with primary key (PK) presented in each table. Than you can join tham for processing based on PK.
A horizontal split means that you keep data in separate identically strutured tables based on some cretiria. For example, if your data have a some kind of date you can keep each year or month in separate table.
In any case you will have to design your application to handle the vertical or horizontal split.
HTH
--sb--