>Hi all
>
>I am curious that when in an app I am using views to access data, are the corresponding tables open also, or are they used whenever data is required to be retrieved / updated and then closed again.
>
>Please explain.

When the view is populated, VFP will open the source tables too. Same thing if you issue a TABLEUPDATE. Note that these are opened with no buffering by default. (And you probably want to leave them that way.)

So, if you USE the view, the source tables are opened. If you then close those source tables, but later REQUERY() the view or call TABLEUPDATE(), the tables will be opened again.