Microsoft KB Archive/129010

{| = PRB: Appending from dBASE IV Table That Has Memo Causes Error =
 * width="100%"|

ID: Q129010

The information in this article applies to:


 * Microsoft FoxPro for Windows, version 2.6a
 * Microsoft FoxPro for MS-DOS, version 2.6a

SYMPTOMS
Appending from a dBASE IV file that has a memo field causes a "Cannot convert Memo file for a read-only file" error message.

RESOLUTION
Make a copy of the dBASE IV database and memo files (*.DBF and *.DBT files). Then use the database file. FoxPro will prompt you to convert the memo file. You should then be able to append from the file.

STATUS
This behavior is by design.

Steps to Reproduce Behavior
1. Make a copy of a dBASE IV table (*.DBF) and its associated memo file

(*.DBT) 2. USE the newly created copy. A message box "Convert MEMO file to FoxPro  Format?" will appear. Answer "Yes." Another message box "Remove dBASE  'soft' carriage returns from memos?" will appear. Answer "Yes." A  "Structural CDX file not found" message may or may not appear. Ignore the message if it appears. 3. Append from the original table by using the APPEND FROM command. A  message box "Convert MEMO file to FoxPro Format?" will appear. Answer "Yes." 4. A "Cannot convert Memo file for a read-only database file" error message will appear. 5. Append from the copy with the converted memo file. The error message should not appear. Additional reference words: FixWin FoxDos 2.60a KBCategory: kbprg kbprb KBSubcategory: FxprgTable
 * }