Ah, now I get it. No. Unless you use a server database like SQL Server, Sybase, or Oracle, everything happens on the local machine. This is true even if you access the VFP tables through ODBC.

>Josh,
>I didn't make myself clear, what I mean is , do local views work the same ( basically )as say SQL server where the Query is run on the backend server as opposed to the local machine
>Regards
>Pete Kane
>>I'm not sure I understand your question, but the SQL statement in a view is executed when you USE or REQUERY() the view.
>>
>>>I have an application which although runs locally accesses data from a server, I have a number of local views in my database, where are the stored SQL statements executed?
>>>TIA
>>>Pete Kane