>>Any other ideas?<<
Certainly. Use Stonefield Database Toolkit. It handles all this for you and much more.



>Thanks for the idea, but this won't work if you have long field names or persistant relations in the database container. They will be lost using this method. The long field names can be saved by using the database clause in the copy command:
>
>COPY TO ... FOR !Deleted database XYZDBC
>
>This will not save the relations though. The option then is to do the copy, then ZAP the original file, then append the records back from the copy. Both append processes can use the ShowProgress() function, but this can be a very long process.
>
>Any other ideas?
>
>
>>Hi Mark
>>
>>Essentially PACK is just copying all non-deleted records to a new table. Therefore instead of PACK you could just use COPY TO ... FOR !Deleted() and showprogress().... and then rename the target file and delete the original file when finished.
>>
>>Jos
>>
>>>
>>>Is there any way to do something similar with the PACK command. It does not support the for clause, but there are times when I need to pack large files and it would be nice to let the user know that something is actually happening.
>>>