>>Is there any simple way to enhance the Limit of VFP DBF table beyond 2 GB Capacity ?
>
>Follow a few round rules, and this will not be any problem for a normal size application.
>
>1. Never use general fields. NEVER!!!
>2. Never store pictures in tables, only the name of the picture file, with or without path
>3. Normalize the tables, don't add fields which are seldom used.
>4. Reuse deleted records

We just generate one daily day-end invoice with our retail application with merge all sales but it crush 2 GB barrier every year. If we would be create a record for every POS transactions it would be crush almost every week and also we use deleted records at append new record... . :)

One solution is using a database like sql-server or oracle.