>>>Does anyone know what is the maximum table length. Is there a way to change the length of the table so that I could insert more fields into it??
>>
>>Foxpro limit is 2GB on a table. So just calculate how many records you can use, knowing record size.
>
>I currently have 124 records, 255 fields, and length of 2665. Is it the limit?? Because it doesn't allows me to insert any more fields into the table.

Visual Foxpro System Capacities (on-line help):
Table and Index Files
Maximum # of records per table file 1 billion
Maximum size of a table file 2 gigabytes
Maximum # of characters per record 65,500
Maximum # of fields per record 255
Maximum # of tables open at one time 255 (1)
Maximum # of characters per table field 254
Maximum # of bytes per index key in a non-compact index (2) 100
Maximum # of bytes per index key in a compact index (2) 240
Maximum # of open index files per table unlimited (1)
Maximum # of open indexes in all work areas unlimited (1)
Maximum # of relations unlimited
Maximum length of relational expressions unlimited