PRB: DISPLAY STATUS Wrongly Says Database Opened Exclusively

 Last reviewed: June 3, 1996
Article 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 <database> ALIAS <alias>
   DISPLAY STATUS
Results with file sharing disabled: 

   Currently Selected Database:
   Select Area:  1,  Database in use:  <database>   Alias:  <alias>
   Lock:  Exclusive USE
Results with file sharing enabled: 

   Currently Selected Database:
   Select Area:  1,  Database in use:  <database>   Alias:  <alias>
   Lock:  <none>

Additional reference words: 2.01 2.60a FoxMac multi-user shared
KBCategory: kbusage kbprb
KBSubcategory:

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 3, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.