DOCUMENT:Q141074  11-DEC-1999  [foxpro]
TITLE   :PRB: ErrMsg: "DBC... Previously Opened Non-Exclusively"
PRODUCT :Microsoft FoxPro
PROD/VER:WINDOWS:3.0
OPER/SYS:
KEYWORDS:

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Visual FoxPro for Windows, version 3.0 
-------------------------------------------------------------------------------

SYMPTOMS
========

The Form Wizard fails and displays this message:

   The DBC containing the selected table was previously opened non-exclusively
   and the field(s) you chose for sorting are not in an existing index tag.
   Please select field(s) which already have an existing tag or exit the wizard
   and reopen the DBC exclusively.

This error message occurs if a field for which there is no index is selected for
order by.

CAUSE
=====

The database that the table belongs to has been opened shared and is read-only.

WORKAROUND
==========

Close the database, and reopen it exclusively.

STATUS
======

This behavior is by design.

REFERENCES
==========

For more information about this, please see the following article in the
Microsoft Knowledge Base:

   Q135117 PRB: Unable to Modify Tables in Database Flagged as Read-Only


MORE INFORMATION
================

Steps to Reproduce Behavior
---------------------------

1. On the Tools menu, click Options. Click the Data tab, and clear the Open
   Exclusive check box.

2. Open the Tastrade database in the Samples\Data directory.

3. Notice that it says "Read Only" next to the name of the database.

4. Create a new form using the Form Wizard. Select the Orditems table.

5. In step 3 (Sort Order) select the line_no field for which there is no index.

The error occurs after the Finish button is clicked in step 4.

Additional query words: VFoxWin

======================================================================
Keywords          :  
Technology        : kbVFPsearch kbAudDeveloper kbVFP300
Version           : WINDOWS:3.0

=============================================================================

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.

Copyright Microsoft Corporation 1999.