>Hi,
>
>My application occassionally had this problem of the dbf file
>having double record and the CDX index file also double in size.
>After manually reindexing the file, it will reduce the CDX index
>file size by half.
>
>Is there any way to check this problem from happening before
>my application post the data to this dbf file ?
>
>Thank you

Take a look at http://fox.wikis.com/wc.dll?Wiki~CDXBloat~VFP