>That is the question in a nutshell. Can we get around the VFP 2 Gig file limit. Or do we switch this job to SQL backend, and thank God we code for this possibility...
You may get around it by splitting your DBFs horisontally or vertically (or use a combination) See
http://advisor.com/Articles.nsf/aidp/MATIV02
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison