>I havent really researched.. but there has to ba an easy way to get arround the 2GIG table limit ?
You've got two options if you want to keep the data in VFP. Horizontal or Vertical partitioning.
Verticle would mean you split the table up into two tables with identical structures, one table gets half, the other gets teh other half.
Horizontal means you actually move half of the fields to another table.
Check this out:
http://www.foxtalknewsletter.com/FT/FTmag.nsf/0/968DE30822BF0AF3852568CF0076C959