Microsoft KB Archive/282354

= ACC2002: Database Diagram Design Pane Displays Boxes for Japanese Characters =

Article ID: 282354

Article Last Modified on 9/27/2004

-

APPLIES TO

 Microsoft Access 2002 Standard Edition, when used with:  Microsoft Windows 98 Standard Edition

 Microsoft Windows 98 Second Edition

 Microsoft Windows Millennium Edition

 Microsoft Windows NT 4.0</li></ul> </li></ul>

-

<div class="notice_section">

This article was previously published under Q282354

<div class="notice_section">

Novice: Requires knowledge of the user interface on single-user computers.

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

<div class="symptoms_section">

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.

<div class="cause_section">

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

<div class="resolution_section">

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.

<div class="moreinformation_section">

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.

<div class="references_section">