MOD2000: Can't Add Main Table When There Are Special Characters in a Lookup Table Name

• Microsoft Office 2000 Developer

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.

MORE INFORMATION

Steps to Reproduce Behavior

1. Create a new database on Microsoft SQL Server named test.



2. Create a table named MyMainTable with the following columns and column attributes:




Column name, data type, and length	Other column attributes
MyID; int; 4	Clear Allow Nulls; Select Identity; Use Identity Seed and Identity Increment values that you want. Make MyID the primary key for this table.
MyDescrip; char; 10	Clear Allow Nulls.
SuppID; int; 4	Clear Allow Nulls.



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




Column name, data type, and length	Other column attributes
Supp; int; 4	Clear Allow Nulls; Select Identity; Use Identity Seed and Identity Increment values that you want. Make SuppID the primary key for this table.
SuppName; char; 10	Clear Allow Nulls.



4. Save both tables.



5. Create a new database diagram. Add the MyMainTable and the [MySuppliers] tables.



6. Click the SuppID column in the [MySuppliers] table.



7. Drag the SuppID column over the SuppID column in the MyMainTable table. This establishes a relationship between the two tables.



8. Save the database diagram, and then close it.



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



10. In the Object List, right-click Tables, and then click Add Main Table on the shortcut menu to start the Main Table Selection Wizard.



11. On the Welcome page, click Next.



12. On the User Tables page, select MyMainTable, and then click Next.



13. On the Row-Level Permissions for Main Tables page, click Next.



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

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

Keywords : kberrmsg kbdta modWFDesigner
Version : :
Platform :
Issue type : kbbug