Microsoft KB Archive/92346

{|
 * width="100%"|

-

The information in this article applies to:


 * Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, 2.5a
 * Microsoft FoxPro for Windows, versions 2.5, 2.5a

-

SYMPTOMS
An attempt to perform an action in Microsoft FoxPro fails with an &quot;Exclusive open of file is required&quot; error message.

CAUSE
The user attempted to run one of the following commands on a shared database (one that is not opened for exclusive access):


 * INDEX when creating, adding or deleting a compound index tag
 * INSERT [BLANK] (not SQL INSERT)
 * PACK
 * REINDEX
 * ZAP

RESOLUTION
Open the database for exclusive access, using one of the following statements: 

  USE EXCLUSIVE "-or-"    SET EXCLUSIVE ON   USE NOTE: This also occurs when attempting to perform a ZAP on a .DBF file that is not marked as Excluded in a project.

MORE INFORMATION
To use one of the commands above that requires the database to be opened for exclusive use, close the database, then issue the SET EXCLUSIVE ON command from the Command window. If the database is open, SET EXCLUSIVE ON causes another &quot;Database not opened exclusively&quot; error.

When a database is not opened for exclusive access, the MODIFY STRUCTURE command operates in read-only mode.

NOTE: If a table is added to a project, but not marked as excluded, then the table is opened in read-only mode when the .APP or .EXE built from the project is run.

Additional query words: FoxDos FoxWin multi-user programming 2.x multiuser

Keywords         : FxprgMultiuser Version          : 2.00 2.50 2.50a | 2.50 2.50a Platform         : MS-DOS WINDOWS Issue type       :
 * }