>>According to the help in VFP, the base tables are opened as Exclusive if exclusive property is .T. Are you saying these tables are made local also and another user can access the base tables while the view is opened?
>
>No, the base table are not made local and should be opened as shared. The view is anything but a SELECT-SQL on steroid. VFP will create a temporary table resulting of this SELECT and this table will be local. Any modifications made to this table (assuming that it is updatable) will be sent to the original tables.

That comes back to the question of exclusive property in the view of the data environment. This exclusive property is disabled and set to .T. by VFP. In this case, how can the view work in multi-user environment?

According to VFP help, when exclusive is .T., the base tables will be opened as exclusive On. Is the help giving wrong information?