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.