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

• 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.

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:

   ARTICLE-ID: Q135117
   TITLE     : 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.