Microsoft KB Archive/96341

{| = PRB: DISPLAY STATUS Wrongly Says Database Opened Exclusively =
 * width="100%"|

ID: Q96341

The information in this article applies to:


 * Microsoft FoxPro for Macintosh, version 2.6a
 * Microsoft FoxBASE+ for Macintosh, version 2.01

SYMPTOMS
DISPLAY STATUS shows that a database is opened exclusively in multiuser FoxBASE+/Mac even though the database was opened nonexclusively.

NOTE: This behavior does not occur in Visual FoxPro for Macintosh.

RESOLUTION
File sharing must be enabled for DISPLAY STATUS to show that the database is opened nonexclusively.

MORE INFORMATION
Database management is faster when databases are opened exclusively. For performance reasons, FoxBASE+/Mac checks if file sharing is enabled before opening databases nonexclusively. The following examples demonstrate the difference in DISPLAY STATUS when file sharing is off and when it is on.

SET EXCLUSIVE OFF USE ALIAS DISPLAY STATUS Results with file sharing disabled: Currently Selected Database: Select Area: 1,  Database in use:    Alias: Lock: Exclusive USE Results with file sharing enabled: Currently Selected Database: Select Area: 1,  Database in use:    Alias: Lock: Additional reference words: 2.01 2.60a FoxMac multi-user shared KBCategory: kbusage kbprb KBSubcategory:
 * }