Knowledge Base

BUG: ALTER TABLE Causes Memo File is Missing or Invalid Err

Article ID: 191593

Article Last Modified on 5/12/2003

APPLIES TO

Microsoft Visual FoxPro 3.0 Standard Edition
Microsoft Visual FoxPro 3.0b Standard Edition
Microsoft Visual FoxPro 5.0 Standard Edition
Microsoft Visual FoxPro 5.0a
Microsoft Visual FoxPro 6.0 Professional Edition

This article was previously published under Q191593

SYMPTOMS

Using the Alter Table command to add a column to a FoxBASE+ table with a memo field causes the following error message:

Memo file is missing or invalid.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

Create a program (.prg) file and add the following code to the .prg file:

      CREATE CURSOR DummyTable (Code C (5), MemoField M)
      FOR i = 1 to 10
         APPEND BLANK
      ENDFOR

      COPY TO Foxold TYPE FOXPLUS
      USE Foxold EXCLUSIVE
      ALTER TABLE Foxold ADD COLUMN Descr C(80)

Save and run the .prg file.

NOTE: The program errors out with the error message shown in the SYMPTOMS section.

Additional query words: kbVFp300bbug kbVFp500abug kbVFp600bug KbDBFDBC kbDatabase

Keywords: kbbug kbnofix KB191593