ACC2002: Database Diagram Design Pane Displays Boxes for Japanese Characters (282354)



The information in this article applies to:

  • Microsoft Access 2002, when used with:
    • the operating system: Microsoft Windows 98
    • the operating system: Microsoft Windows 98 Second Edition
    • the operating system: Microsoft Windows Millennium Edition
    • the operating system: Microsoft Windows NT 4.0

This article was previously published under Q282354
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access project (.adp).

SYMPTOMS

When you attempt to create a new database diagram in a Japanese Microsoft Access project, the Japanese characters in the table name and the field names are displayed as boxes.

CAUSE

This behavior occurs because the Tahoma font used by the operating systems listed in the "applies to" section of this article does not contain Kanji characters.

RESOLUTION

To work around this issue, be sure to create, edit, and view the database diagrams with Microsoft SQL Enterprise Manager. For more information about how to use SQL Enterprise Manager, consult the SQL Server Books Online.

MORE INFORMATION

Steps to Reproduce the Problem

Please note the following:
  • This behavior does not occur if the operating system is Microsoft Windows 2000.
  • You must have a Japanese font installed to perform this procedure.
  1. Start Microsoft Access and in the New File task pane, click Project (Existing Data).
  2. Name the file TestNWindJpn, and then click Create.
  3. In the Data Link Properties dialog box, type the name of any SQL Server computer to which you have access, a valid user name, and a database with Japanese characters.
  4. Under Select the database on the server, click the database with Japanese characters, and then click OK.
  5. In the Database window, click Database Diagrams under Objects, and then click New.
  6. In the Add Table dialog box, select a table, click Add, and then click Close.

    Notice that the Japanese characters in the field names in the added table are displayed as boxes.

REFERENCES

For more information about creating database diagrams, click Microsoft Access Help on the Help menu, type create a database diagram in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Modification Type:MinorLast Reviewed:9/27/2004
Keywords:kbprb KB282354