ACC: MS Access Converts Extended Chars in Linked FoxPro DBF

• Microsoft Access versions 1.1, 2.0, 7.0, 97
• Microsoft FoxPro for Windows, versions 2.5a, 2.5b, 2.6

SYMPTOMS

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

Extended characters (ANSI characters greater than 128) that you enter in a linked (attached) FoxPro table are converted to other characters when you commit the record.

CAUSE

The ISAM that Microsoft Access uses to link FoxPro databases reads a Code Page flag in the header of the FoxPro database. This flag tells the ISAM how to handle OEM to ANSI conversions. In this case, the flag is set to convert ANSI characters to OEM characters.

RESOLUTION

To prevent the ISAM from performing ANSI to OEM conversions, add the following line to the FoxPro configuration file CONFIG.FPW:

   CODEPAGE=AUTO 

MORE INFORMATION

This resolution will not correct character conversions that were made prior to your changing the Config.fpw file. To correct conversions that have already been made, port the data from the existing FoxPro database to a new FoxPro database. Consult the FoxPro documentation for information on how to port data from an existing database to a new database.

Keywords : kb3rdparty IsmXbase
Version : WINDOWS:1.1,2.0,2.5a,2.5b,2.6,7.0,97
Platform : WINDOWS
Issue type : kbprb