Rushmore really isn't relevant here. Jan is adding records to a view. Jan, there have been some threads here about this very issue. You may want to search for them. Also, you may want to look into using SQLEXEC() instead of a view for adding a large number of records. I have a feeling that there's some kind of memory leak in VFP involving appending data to remote views. The SQL Server BCP feature might also be an option, but it's not very flexible.
>Remote views are not Rushmore optimizable. The whole IDEA behind C/S is to get small set of records at the time (i.e. Select a phone number from a list of area codes). So dont get all phone numbers load only area codes. Then using an area code as a parameter for your remote (parameterized!!) view get records a user is looking for.
>Hope I helped. Mark