Hi Jim

True, but it doesn't alter the fact that VFP is still capable of addressing up to 2 billion records in a single file.

Whether you can actually create that many or not is beside the point <g>


>Andy,
>
>Actually, the max. records is 1 billion, that being a 1-byte record plus the deleted flag. Makes for lots of dupes.
>
>
>>>There is still size limit for dbf file in fox 7 or not.
>>
>>Hi Mohammed
>>
>>The limits for VFP 7.0 are:
>> Maximum File size for a single file: 2Gb
>> Maximum Records for a single DBF: 2 Billion
>>
>>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.