>>>>Hi Claude
>>>>>1. Why does table Tx have fewer records then table x?
>>>>
>>>>The original table has deleted records. So, they are not missing. You can use count function to see how many active records are in the original table.
>>>>I bet you will have the very same number with select statement
>>>>
>>>>>2. What is the best way to find what records are missing?
>>>>
>>>>DO you need deleted records too?
>>>
>>>I think so. It would be the safest way to go.
>>
>>Then I would COPY FILE instead of using SELECT.
>
>I used select because the file is on a shared server and is being used. Can I sill use COPY FILE?

Yes, you can. However it may slow down the performance on the user side under some circumstances, like it is a big table and there are problems on the network. In any case, if you wish to archive the table, it would be better to do it when all users quit.