>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?

I understand the view, being a temporary DBF, has the same limit. You will have to try to select only relevant pieces of each individual table.

If you have images in general fields, try to put them into separate files (for instance, JPG files), and use references to those in a small character field.

If you simply have many millions of records, your only choice (apart from C/S) might be to split the table horizontally and vertically, as you are trying to do.