I don't know what's the reason (maybe something on SQL side?, I would try to add to empty SQL-table to test it). However, the quick way (I believe you found it already) is to split your table on two and fill remote view two times.

>Hiya Ed ---
>
>Always bombs out on the same relative record. So if I delete that record, it'll still bomb on the "n-th" record....
>
>
>>>Hi All ---
>>>
>>>Have an interesting problem.....trying to update a SQL Server table via a remote view. The view is built using INSERT INTO within a SCAN of a local table of about 28,000 records. At about record 27,000 VFP generates an Invalid Page Fault in VFP.EXE and dies. Now this happens regardless of buffer mode and the record it dies out is perfectly valid.
>>>
>>>Any ideas?
>>
>>Does it always bomb on the same record? If so, I would try to delete it and run again.