>just some ideas :
>
>1. reindexing is not sufficient, rebuild indexes instead (do this after 2. below)
>
>2 .instead of copy to a temp file, sort the file on its primary key to a temp file, it also increases performance
>
>
>Christian

Thanks, Christian. As I said to Arnon, I DID rebuild the indexes - deleted them, closed the table and then re-wrote them from scratch.

Thanks for the suggestion about the sort. Good idea.

Barbara