DBSetShared(open-mode)

DBSetShared determines how files are opened. This function is only available for the multi-user and client/server versions of FileFlex. In the single-user version of FileFlex, data files are always opened exclusively. DBSetShared takes one parameter, an open-mode code. The three valid open-mode codes are;

• "x" - open exclusively, no other users may access the file
• "rw" - open the file read/write, all other users may access the file
• "rs" - open read/shared, the original user may write, all others may read the file, but not write to it.

Some notes on multi-user files: FileFlex will attempt to access a locked file or record at approximately one second intervals. It will continue to do so until it gains access. If we find this becomes a problem, in a future version we may allow you to set the number of access attempts or time. Also, to prevent conflict or "deadlock", be sure that all users always lock and unlock records and files in exactly the same order.

put DBSetShared("rs") into theResult 
put DBUse("VIDEO.DBF") into dbID