>I have a remote view created. I have in the options panel, open exclusive set to off. I have in my main program, SET EXCLUSIVE OFF, and even put it on the form. However...When the form with the view is run, its still being reported as being opened exclusively which is something I don't want. How can I change this behavior on the views opened?
>
>Thanks
>
>Gary


If you think about, views can only be exclusive because it is a subset of data from the source. Your subset is exclusive because the data for the view is tied to a temporary file that is local to your system. On the other hand, even though this view is 'exclusive to you' the data it represents is not exclusive. No locks are attached to the records that relate to the records in your view.

If you use a view, you cannot lock data records in the underlying table (except during the tableupdate). Once the data is retrieved, the connection is lost until you try to do the update. This makes sense when using SQL Server views or Oracle remote views, but not quite as much when the views are based on local data.

Bottom line is your views are now 'local' so they appear exclusive!