>how to solve the problem , when the database (dbf) file is more than 2GB. Because that would not allow to add new data . thank's
Some things you might do:
Split the table vertically - put some fields into another table.
Split the table horizontally - by client, date, geographic region.
Put image (General) fields, or large memo fields, into separate files - keep only the filename in your database.
Try other size optimizations, for example, using integer fields instead of N(8).
But if you have too much data, in the long run the only practical solution might be a client/server solution - using a database server that doesn't have a 2 GB limitation.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)