>Quite true, Victor, but the original code uses 'SEEK' on tables that are now 700K+ records. Sure aren't going to do a view for all the records and then index it :-). We've changed to parameterized views, and the users just have to learn that they can't skip from one record to the next for 700,000 records.
>

Yep. That's why I always do my apps based only in views, even if I'm COMPLETELY sure that the data will be always local < g >. In the past it tooks me a pair of complete rewrites. BTW, you can bill a lot more for C/S apps so I write every new local data app using MSDE instead of the VFP engine. It's not true that you can develop your apps using local views and then transform them to remote views for C/S. When you have complex apps, the diferences between SQL Sever and VFP SQL dialects makes two separate apps a must.

Regards