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