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

The information in this article applies to:

Microsoft Visual FoxPro for Windows 3.0
Microsoft Visual FoxPro for Windows 3.0b
Microsoft Visual FoxPro for Windows 5.0
Microsoft Visual FoxPro for Windows 5.0a
Microsoft Visual FoxPro for Windows 6.0

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.

Modification Type:	Major	Last Reviewed:	5/12/2003
Keywords:	kbbug kbnofix KB191593 kbAudDeveloper