Table and Index Files

Maximum # of records per table file 1 billion
Maximum size of a table file 2 gigabytes
Maximum size of an FPT file 2 gigabytes
Maximum # of characters per record 65,500
Maximum # of fields per record1 255
Maximum # of tables open at one time2 65,535
Maximum # of characters per table field 254
Maximum # of bytes per index key in a non-compact index3 100
Maximum # of bytes per index key in a compact index3 240
Maximum # of open index files per table2 Unlimited
Maximum # of open indexes in all work areas2 Unlimited
Maximum # of relations Unlimited
Maximum length of relational expressions Unlimited

Aashish

>To All,
>
>What is the maximum size of a vfp database or table? Is it bigger than Access (2GB)?
>
>Thanks.
>
>Frank