> but you can't beat a view for quickly accessing data.

Is that "quickly" as in performance or development. I'll definitly agree that it's faster to code around a view because VFP handles so much for you. But, IMO, the flexibility and control quickly exceed the ability to drag columns from a view onto a form. Again, my opinion.

> Beyond that a remote view can be optimized using SQL prepare.

Be careful with SQLPrepare. When you prepare a sql statement, It's under the assumption that it will be called multiple times with only the parameters changing. SQL Server does a lot of work that's only of value if this assumption is valid.

> Building an entire application justs by using stored procedures just doesn't make sence to me.

What's the difference between calling a stored procedure and submitting an ad-hoc query from your point-of-view. I'm not trying to be argumentative - honest.

-Mike