ACC: Exporting Table with OLE Object or Memo Field to Paradox
ID: Q93928
|
The information in this article applies to:
-
Microsoft Access versions 1.0, 1.1, 2.0
SYMPTOMS
Novice: Requires knowledge of the user interface on single-user computers.
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.
MORE INFORMATIONSteps to Reproduce Behavior
- In Microsoft Access, copy any existing table to a new name.
- In Design view, add an OLE Object field or Memo field to the copied
table.
- 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: "Invalid Data Type." However, the TESTFLD.DB file is
created.
- Import TESTFLD.DB using Paradox 3.x as the Data Source.
- 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 : kb3rdparty IsmPdox
Version : 1.0 1.1 2.0
Platform : WINDOWS
Issue type : kbprb
|