Sir,
While Searching on Google I found some Information on how to increase the data size over 2GB, but dont have still Evaluated that. Here is the link.


http://devzone.advantagedatabase.com/jeremym/fox_large/foxprolarge.html


AND


http://devzone.advantagedatabase.com/dz/webhelp/advantage10/index.html?devguide_connecting_to_advantage_using_the_advantage_odbc_driver.htm

-------------------------------



>>Is there any simple way to enhance the Limit of VFP DBF table beyond 2 GB Capacity ?
>
>Follow a few round rules, and this will not be any problem for a normal size application.
>
>1. Never use general fields. NEVER!!!
>2. Never store pictures in tables, only the name of the picture file, with or without path
>3. Normalize the tables, don't add fields which are seldom used.
>4. Reuse deleted records