ACC2002: Unexpected Characters Appear in a Database That Was Converted from a Localized Version of an Earlier Version of Access (291224)

Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

For a Microsoft Access 2000 version of this article, see 222446.
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

CAUSE

When you convert an older database to Access 2002, Access uses the sort order to determine which code page to use for converting the data to Unicode. Access 2002 associates the General sort order with the Western European code page, so if non-Western European data is stored in the General sort order, the data is corrupted when Access 2002 converts it.

Because you are converting the database on an English version of the operating system, the collating order for the converted database is English; therefore, it converts the text to ANSI Unicode characters rather than to Greek Unicode characters.

For example, a database that was created in Access 95 on the Greek version of Microsoft Windows 95 is based on the Greek code page. When an Access 2002 user who is running the English version of Windows 95 opens the database, the operating system maps code points to the new code page; therefore, some Greek characters might appear as accented European characters, question marks, open boxes, or other unintelligible characters.

RESOLUTION

How to Convert a Database from Localized Versions of Earlier Versions of Access

Method 1: Using the Original Language Sort Order

If the older database is based on a non-English version of the operating system, and it is saved in the General sort order, you can recompact it in the original language sort order before converting it to Access 2002. To do so, follow these steps:

Open the database in the original, localized version of Access.

You must open the database on a computer that is running the same language version of the operating system as that used to create the database. Or you can open the database on a computer that is running Microsoft Windows NT 4.0 or Microsoft Windows 2000 with language support for the original sort order.
Change the sort order to match the language of the operating system, and then recompact the database.

NOTE: Steps for changing the sort order and compacting the database are different with different versions of Access.
Start Access 2002, but do not open the database.
On the Tools menu, point to Database Utilities, point to Convert Database, and then click To Access 2000 File Format or To Access 2002 File Format.
In the Database to Convert From dialog box, select the database that you want to convert, and then click Convert.

Method 2: Specify the Code Page for the General Sort Order

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

If you do not have the necessary language version of the operating system, or if the data in the older database is in a language that had no sort order in earlier versions of Access, you can still convert the database to Access 2002.

For example, databases in earlier versions of Access that are based on a Vietnamese, a Farsi, or a Baltic version of the operating system (Estonian, Latvian, or Lithuanian) default to the General sort order because earlier versions of Access did not support sort orders for those languages. To convert these databases, you must create a registry entry to prevent Access 2002 from corrupting the non-Western European data.

To convert non-Western European databases that use the General sort order:

If you are converting an Access version 1.x or 2.0 database, browse to the following registry subkey: HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Jet 2.x
-or-

If you are converting an Access 95 or Access 97 database, browse to the following registry subkey: HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Jet 3.x
In the Jet 2.x or Jet 3.x subkey, create a new entry named ForceCP, and then set the value to ANSI to use the computer's default code page. You can specify a different code page by setting the value to the code page number, such as 1257 for Windows Baltic Rim.
Convert the database to Access 2002.
Delete the ForceCP registry entry so that Access 2002 reverts to using the sort order of a database to determine the code page.

MORE INFORMATION

Steps to Reproduce the Behavior

On a clean computer (a computer that has a newly installed version of Windows, and no other applications), install the Greek version of Windows 98 and the Greek version of Access 97.
In Control Panel, double-click Keyboard, and then click the Language tab.
Click Gr, and then click Set as Default.
Click OK, and then close Control Panel.
Use the Greek version of Access 97 to create a new database.
In the new database, create a table with three text fields.
View the table in Datasheet view.
Create several records, typing Greek characters in all three fields.
Close the database.
Move the database to a computer that is running the U.S. English version of Windows 98 and the U.S. English version of Access 2002.
On that computer, open Access.
Open the database.
Click Convert Database, and then click OK.
Open the table that you created in step 5.

Note that the characters are not the same ones that you entered in the table in step 7. Many appear to be extended characters.