ACC: Microsoft Access Converts Extended Characters in Linked FoxPro DBF

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.

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.

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

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.