>>The maximum size of any file in VFP is 2GB. If you need to store data that exceeds that size you need to partition the data into multiple files.
>
>Once a table is full - would archiving data in that table be a viable strategy? How long does it normally take for a table to fill up.
>
>Thank Jim.
You have to estimate how fast your table is going to grow, based on your business data.
One reason archiving isn't practical is because of referential integrity. For instance, my users in Bata Shoe Organization wanted to delete shoes that were no longer produced. I explained them that due to RI, as long as there was related data in any other table, the system didn't allow deleting the shoe. And if the factory stopped producing a shoe, years later, there could still be remainders in the warehouse, which had to appear in the system...
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)