>In the near future is Microsoft Planning to increase the file size of a table from 2GB.
>
>Currently the max. limit of a file size is just 2GB for foxpro tables.
>
>Lot of times people ask us at the trade show, Can foxpro handle millions of records.
>
>I know we have a database table with only 150,000 records init and the size is near to 1 GB.

Your number seems odd, Raj... wouldn't that mean that your records are something over 6,000 character positions EACH??? IF that is correct then surely you have room for some design changes.

IF, however, you are referring to a .FPT file of that size (which seems more likely to me) then you can periodically - can only be done in EXCLUSIVE mode - PACK MEMO the table in question to eliminate any 'bloat' that exists in the .FPT.

good luck