The "Not a table "error implies its corrupted.

If you have many deleted records or a a large memo file packing the table may help.

Otherwise you have to change the structure of your data.

Are you storing repeated data like addresses, descriptions etc which could be held in a different table and looked up.

Or you could split the file in two horizontally or vertically. So 1st half of the data is in one file 2nd half in another file, or 1st half of each record is in one file 2nd second half is in another file.


>i have a problem in Visual Foxpro with an error message of "NOT A TABLE" ????
>
>
>CAN ANYONE HELP ME..
>
>
> HOW TO FIX THE CORRUPTED DBF FILE BECAUSE THE FILE SIZE IS MORE THAN 2 GB..????
>
>WHAT ARE THE BEST SOLUTION TO MINIMIZE THE FILE SIZE OF THE DBF FILE.???
>
>
>
>
>THANK YOU IN ADVANCE..