Hi,

We only add new records and never edit an existing one. The memo field content is never over 50 characters long, just some note about what occured.

Also, the DBF is just too big at 20Mb. The recsize() is only 89 Bytes and it only has 44 records.

Thanks,
Arriyel

>Arriyel, because of what Yuri has already pointed out using a memo field for log operations is a bad idea if the same record's memo field is going to be re-used or added to often.
>
>If you are just adding records and each record has some memo data thats fine. But the bloat starts when you try to add to and/or keep changing an existing memo field.
>
>
>
>>Hi,
>>
>>We're getting a very strange problem with one of our log files. The table has 9 fields with 1 memo field.
>>
>>The file acts like an audit log and just keeps track of start and stop events and addition/modification of tables when a custom data import program is running.
>>
>>The problem is that when the data import program runs, the file seems to grow very fast very quickly within a couple of weeks. The last time this occured, the DBF file was 20Mb and the FPT file was 80Mb with only 44 records. We can browse the table (and memo fields) fine but when we packed the table, the DBF file remained at 20Mb but the FPT was just 20Kb.
>>
>>We've tried deleting the table and recreating a new one, but this works for only a few days then were back to the same problem.
>>
>>Any help is greatly appreciated.
>>
>>Thanks,
>>Arriyel