>Hi Calvin.
>
>>I am using VFP 7 and Stonefield 6.0b. Recently a client started having trouble doing database maintenance. He was getting not enough memory errors. I got a copy of his DBC and discovered that there were 65502 deleted "Index" records in it. Each index in the DBC had 267 duplicate deleted entries. What would cause this?
>
>Interesting -- two essentially identical questions the same day.
>
>This is because in order to recreate the indexes for the table, it has to delete the existing records for those indexes in the DBC. New copies of those records are then created as the indexes are created. I considered doing a PACK DATABASE at the end, but that requires exclusive access to the DBC to work, and I can't guarantee that'd be the case. So, simply do your own PACK DATABASE.
>
>Doug
See my posting in Debra Stubbs post for a programmatic solution to this.
-Justin