No, the tables size will remain until it is PACKed. However, if you recycle your records as you add new data then there wouldn't be a problem with size.

How large is your table (number of records) and how many get deleted each day? Will you have more than 10% deleted at any time?

Barbara

>Actually I write the codes in VB6 and I don't need the deleted records I knew that the default value of VFP tables is Set deleted on that users can not see the deleted records, but by the way how about the table's size? because I don't think so the size will changes to smaller when the records deleted before they packed.. thank you