Hi Stephen,

Did you consider moving this processing to SQl Server?

There's also CodeBase library for C/C++ that allows to create tables bigger than 2gb http://codebase.com/.

>I know that VFP tables are limited to 2 gig. But I also mention the possibility of C++. If we use C++, OLE DB/ADO, is the resulting dataset as retrieved by ADO limited to 2 gig? Suppose VFP is only instantiating ADO, can ADO retrieve a dataset larger than 2 gig?
>
>Thanks,
>Steve
>
>
>>Hi Stephen,
>>
>>The size of the VFP tables is limited to 2Gb regardless where data is comming from.
>>
>>>In time we will have the need to transfer potential data sets in excess of 2 gig for viewing by an end user from terabytes of data. We need to know the best connectivity to use for this: ODBC (currently used), ADO, OLE_DB, etc. what's the fastest and best for this application? The current application is also written in VFP and we need to know if the 2 gig size limit will affect the return of data or whether VFP will need to be converted to C++ in order to accomodate these larger data sets. Even if C++ is eventually used, we'd still need an answer for the connectivity method to a SQL-Server or Oracle backend.
>>>
>>>Thanks,
>>>Steve