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?