Specifies whether Visual FoxPro opens table files for exclusive or shared use on a network.




(The default for the global data session.) Limits accessibility of a table opened on a network to the user who opened it. The table isn't accessible to other users on the network. Unlike FLOCK( ), SET EXCLUSIVE ON also prevents all other users from having read-only access. A file can also be opened on a network for exclusive use by including the EXCLUSIVE clause with the USE command. It isn't necessary to perform record or file locking on a table opened for exclusive use.

Opening a table for exclusive use ensures that the file can't be changed by other users. For some commands, execution isn't possible until a table is opened for exclusive use. These commands are INSERT, INSERT BLANK, MODIFY STRUCTURE, PACK, REINDEX, and ZAP.


(The default for a private data session.) Allows a table opened on a network to be shared and modified by any user on the network.

For additional information about record and file locking and sharing tables on a network, see Programming for Shared Access.

Expand imageRemarks

Expand imageSee Also