Rod,

>How is automatic memory/disk spanning different than a memory swap file handled by the OS ?

It is very different, because the swap file is not as scalable it is used to swap process memory in and out. The automatic disk spanning feature found in cursor in VFP does not eat up process memory. So a small VFP executable that handles large cursors still processes in a small amount of memory. With ADO.NET, the process eats up all assigned physical memory and after that all the virtual memory until your Windows because non-responsive. IOW, you can't scale applications using ADO.NET this way as you can do with the VFP equivalent using cursors.

Walter,