I have a new shared networked application that uses the same free tables as another shared networked application. Ran into some trouble when application1 has the table in USE and application2 wants to USE the table. Started looking at the USE statement and got even more confused. I always thought that EXCLUSIVE meant exclusive. I have EXCLUSIVE to open tables when there is system maintenance to perform. But then the SHARED says that it can also USE a table that was opened EXCLUSIVE. Under normal conditions (not system maintenance, etc), on a shared network aplication would you just "USE table1.dbf in 0" without the SHARED? Why would you use the SHARED? So confused.

EXCLUSIVE
Opens a table for exclusive use on a network. For more information on the exclusive use of tables, see SET EXCLUSIVE.

SHARED
Opens a table for shared use on a network. SHARED allows you to open a table for shared use even when EXCLUSIVE is set ON.


Brenda