Microsoft KB Archive/141074

= PRB: ErrMsg: "DBC... Previously Opened Non-Exclusively" =

Article ID: 141074

Article Last Modified on 12/11/1999

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition

-



This article was previously published under Q141074



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.



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: KB141074

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.