Will do, Val - could you tell me what issue it was in? I've got an awfully tall stack of Advisor mags...

I recall reading it, but clearly didn't retain the details (sheepish grin)...

>Michael,
>
>You have to be creative in breaking the 2G limit. I am one of the few on this forum who actually has done it. You will have to partition your data - no question. Please look at Foxpro Advisor for the article I wrote on the Eurotunnel App - 128 gig of data under Fox. I'm the guy who wrote it.
>
>BTW, my reply does not help you but the article will.
>
>- Val Matison
>
>
>>I have a friend who's trying to avoid going to SQL, but has a VFP table nearing the 2GB limit. He has tons of reports written using this table.
>>
>>I though we might postpone the inevitable if we split the table into several pieces and joined them using a view - but it occurred to me that if the view creates a 2.5 GB temporary table in the background, we might be screwed anyway.
>>
>>So my question is: Is it possible to create a VIEW greater than 2GB in VFP?