Hi,

> - how do you execute a view from VFP7

you can treat a SQL Server view just like a regular SQL Server table.

> - if it's on another server do I use the client tools to gain access to the server and create an ODBC connection to it?

You can receive data from any SQL-Server using SQL Pass Through or VFP remote views.

HTH,
Armin