Microsoft KB Archive/247374

= MOD2000: Cannot Add Main Table When There Are Special Characters in a Lookup Table Name =

Article ID: 247374

Article Last Modified on 7/31/2001

-

APPLIES TO


 * Microsoft Office 2000 Developer Edition

-



This article was previously published under Q247374



SYMPTOMS
In Access Workflow Designer, when you add a main table that has a related lookup table which has one or more special characters in its name (such as . * [ ] \ | / < > : " ? '), the Main Table Selection Wizard stops and you receive an error message similar to the following:

Access Workflow Designer

This process cannot continue because of the following error:

Error: (0x80040E14) Table: mysuppliers [with brackets cannot be added to modObjects. The identifier must NOT include any of these characters:. * [ ] \ | / < > : " ? '



CAUSE
Unlike Microsoft SQL Server 7.0, Access Workflow Designer does not support the use of one or more special characters in lookup table names.



RESOLUTION
Rename the related lookup table in Microsoft SQL Server Enterprise Manager so that it does not use any of the special characters mentioned in the "Symptoms" section. After you have modified the table name, add this table to the previously saved database diagram again in Microsoft Access. Then, rerun the Main Table Selection Wizard.



Steps to Reproduce Behavior
 Create a new database on Microsoft SQL Server named test . Create a table named MyMainTable with the following columns and column attributes:

 Create another table named [MySuppliers]. (Be sure to include the brackets ([ and ]) in the table name). Create the following columns and column attributes:

 Save both tables. Create a new database diagram. Add the MyMainTable and the [MySuppliers] tables. Click the SuppID column in the [MySuppliers] table.</li> Drag the SuppID column over the SuppID column in the MyMainTable table. This establishes a relationship between the two tables.</li> Save the database diagram, and then close it.</li> Start Access Workflow Designer. If this database has not previously been registered with the Access Workflow Designer, you are prompted to do so at this time.</li> In the Object List, right-click Tables, and then click Add Main Table on the shortcut menu to start the Main Table Selection Wizard.</li> On the Welcome page, click Next.</li> On the User Tables page, select MyMainTable, and then click Next.</li> On the Row-Level Permissions for Main Tables page, click Next.</li> On the Completing the Main Table Selection Wizard page, click Finish. Note that you receive the error message mentioned at the beginning of this article.</li></ol>

Additional query words: pra can t special characters lookup relationship period left right question mark back slash less greater than asterisk quotation colon apostrohe pipe symbol trying to

Keywords: kberrmsg kbbug kbpending kbworkflowdesigner KB247374

-

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

© Microsoft Corporation. All rights reserved.