>
However, these limits apply to single files, it is perfectly possible to 'partition' tables so that a single "table" uses several files if you have really large volumes of data.>
>Better in this case (big tables) use SQL Server (for development you can use the free MSDE engine.)
>
>
http://msdn.microsoft.com/library/default.asp?URL=/library/backgrnd/html/msdeforvs.htmHi Zlatin
With all due respect, that is not really an alternative. The development environments and system requirements of VFP and SQL Server (not to mention the licensing and maintenance issues) are in no way comparable - there are many situations in which SQL Server (or Oracle) is simply not a practical solution - but large volumes of data still need to be handled.
----
Regards
Andy Kramek