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

• 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 INFORMATION

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: "Invalid Data Type." 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.