>I have a form that contains 6 remote views in the data environment. Five of the views are set for optimistic table buffering with the other set for optimistic row buffering. I am using these views to query and make sure a value that is going to be entered is not a duplicate. If not a duplicate then I issue an INSERT followed by a =tableupdate()
>
>The problem is that when one machine is running this application it seems as if no one else can access those tables until that form is released. Perhaps I am mistaken, but I thought that optimistic table buffering with views meant that copy of the data is pulled down to a temporary table, without locking the data. The only time I thought the records would be locked is when a =tableupdate() is issued.
>
>This application will be rapidly moving toward multi-user usage and I am not sure what I am doing wrong here. Any help would be appreciated.
>
>Environment:
>OS: Win95
>Back End: SQL Server 6.5
>Front End: VFP 5.0
>
>Thanks,
>George

Hi,

It seems to me that you are opening your table (in the DE) exclusively. Set exclusive to off. That's probably why the others don't have access to some table when the form is opened.