ACC97: FoxPro File Imported or Linked by Using ISAM Driver Shows Data Where Null Should Be (269663)
The information in this article applies to:
This article was previously published under Q269663 Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you use the FoxPro ISAM driver that is included with Microsoft Access 97 to import or link a Microsoft Visual FoxPro 3.0 file that has fields that contain nulls, you notice that those fields now contain data.
CAUSE
The fields originally contained data, and then later, this data was replaced by nulls in Microsoft FoxPro. The FoxPro ISAM driver does not recognize this, and instead shows the original data of those fields.
RESOLUTION
To display the information correctly, link or import the file by using the Visual FoxPro ODBC driver rather than the FoxPro ISAM driver.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 9/26/2003 |
---|
Keywords: | kbbug kbnofix KB269663 |
---|
|