Yes, each file (DBF, FPT, CDX) of VFP table has independed limit of 2GB.
Your idea may work but is it simple or not to implement would depends on an application design.
How would you know what the current Memo table # is at the time of insert?
How would you know what Memo tables to open in case of data retrieval?
How would you handle multiple memo fields per record?
>I have been thinking about something tonight in regards to the 2 Gig limit of Visual FoxPro. AFAIK, the limit is reached as soon as one of the related files for a table reaches the size of 2 Gig. So, if I have 4 millions records in Table.dbf for 135 Meg, with a Table.cdx for 45 Meg and Table.fpt for 1.8 Gig, it means that as soon as the first file associated with that reaches the 2 Gig limit that it won't work anymore. So, basically, the memo file is likely to reach that limit first.
>Assuming that is true, and please someone can validate this, the simplest thing to do to continue work as is with this table would simply be to create an additional field in Table.dbf, such as TableID of type Integer, for example, which can hold the location of the memo file associated with that record.
>
>For example, let say I have this for the first five records of Table.dbf:
>
>>Numero Title AddDate TableID
>1 My first tile 05/05/2005 11:11:11 1
>2 My second tile 05/05/2005 11:11:11 1
>3 My third tile 06/05/2005 12:11:11 2
>4 My fourth tile 06/05/2005 13:11:11 2
>5 My fifth tile 06/05/2005 14:11:11 2
>
>
>Let say I have this in TableMemo1.dbf:
>
>>Numero NoTable Notes
>1 1 Memo
>2 2 Memo
>
>
>And this in TableMemo2.dbf:
>
>>Numero NoTable Notes
>1 3 Memo
>2 4 Memo
>2 5 Memo
>
>
>Then, it would mean, I would only have to create a new TableMemoX.dbf when the limit is about to reach 2 Gig and adjust a small portion of the code to know where to get the memo when needed and where to save it at save time. Of course, I would need to transfer the memo field from Table.dbf and scale it down to TableMemoX.dbf.
>
>Is this about the simplest way to go to workaround that 2 Gig limit?
>
>Any confirmation?
--sb--