>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.