Knowledge Base

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

Article ID: 141074

Article Last Modified on 12/11/1999

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.

REFERENCES

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

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

MORE INFORMATION

Steps to Reproduce Behavior

On the Tools menu, click Options. Click the Data tab, and clear the Open Exclusive check box.
Open the Tastrade database in the Samples\Data directory.
Notice that it says "Read Only" next to the name of the database.
Create a new form using the Form Wizard. Select the Orditems table.
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