Microsoft KB Archive/93928

= ACC: Exporting Table with OLE Object or Memo Field to Paradox =

Article ID: 93928

Article Last Modified on 5/9/2003

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q93928



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



SYMPTOMS
When you export a table from Microsoft Access that contains a field with an OLE object or Memo data type in Paradox 3.x format, the resulting Paradox table contains one entry that says m_i_c_r_o_s_o_f_t. You can see this result by importing the Paradox table you just exported and then opening the table.

Microsoft Access version 2.0 can export Memo and OLE fields to Paradox 4.x format. If you export Microsoft Access version 2.0 Memo or OLE fields to Paradox 3.x format, the behavior mentioned above will occur.



Steps to Reproduce Behavior

 * 1) In Microsoft Access, copy any existing table to a new name.
 * 2) In Design view, add an OLE Object field or Memo field to the copied table.
 * 3) After saving and closing the table, export it, choosing Paradox 3.x as the data destination and TESTFLD.DB as the name. Note that you receive the error: &quot;Invalid Data Type.&quot; However, the TESTFLD.DB file is created.
 * 4) Import TESTFLD.DB using Paradox 3.x as the Data Source.
 * 5) Open the resulting table. You will see a table consisting of one field with the field name m_i_c_r_o_s_o_f_t and the data type Number, but there is no data in the table.

Paradox is manufactured by Borland International, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

Keywords: kbprb kb3rdparty KB93928

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.