PMFJI.

From VFP Help
----------
local view: A view that uses Visual FoxPro tables within the current database.
remote view: A view that uses data sources outside of the current database, such as Microsoft SQL Server.
----------

>Thanks for the info bill. Actually we were able to speed up the app significantly (access a record went from 25 sec to 6 on a P166) by using views instead of the accessing the table directly. But here's my new question: We are using local views and then accessing them like you said (nodataonload and then define the parameter and then requery()). What is the difference with a remote view? We only use one DBC for the App wich is on a Novell file server.