Strangely enough, we're covering this very topic in another thread right now. Actually, fox does have a 2GB limit on .dbf, .fpt, and .cdx files. Sounds like this restriction may have been somewhat loosened in VFP 8.
As far as encountering probs at the 1GB size, I haven't experienced that one before. What all is acting on this table (or that Memo specifically)?