The one table will be 330,000 records, about 96 Mb.
W.
>If that is always case, and depending on the size of the tables involved, it might be easiest to simply copy the entire table to the remote location.
>
>>The table at the remote location is always going to be out of date. Yes, I will add a time stamp.
>>W.
Winn Pauley