Microsoft KB Archive/812696

= Error 41: &quot;Memo file is missing or invalid&quot; error message when you access Visual FoxPro tables on a computer that is running Windows Millennium Edition or an earlier version of Windows from a computer that is running Windows XP =

Article ID: 812696

Article Last Modified on 2/16/2005

-

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 6.0 Professional Edition
 * Microsoft Visual FoxPro 7.0 Professional Edition
 * Microsoft Visual FoxPro 7.0 Service Pack 1
 * Microsoft Visual FoxPro 8.0 Professional Edition
 * Microsoft Visual FoxPro 9.0 Professional Edition
 * Microsoft Windows 95
 * Microsoft Windows 98 Standard Edition
 * Microsoft Windows 98 Second Edition
 * Microsoft Windows Millennium Edition
 * Microsoft Windows XP Professional

-



SYMPTOMS
You use a computer that is running Microsoft Windows Millennium Edition or an earlier version of Windows as a file server. That computer hosts Visual FoxPro tables that contain memo fields. When users with computers that are running Microsoft Windows XP try to access these tables, they may receive the following error message, even though there is nothing wrong with the memo file:

Error 41 &quot;Memo file is missing or invalid.&quot;

In Visual FoxPro 9.0, you may receive the following error message:

Table &quot;name&quot; has become corrupted. The table will need to be repaired before using again. (Error 2091).



CAUSE
The problem is caused by the difference between the file locking in Windows Millennium Edition and earlier versions of Windows, and the file locking in Windows XP.



RESOLUTION
Use a computer that is running Windows XP as the file server.



STATUS
This behavior is by design.



Steps to reproduce the problem
  Use the following code to create a new program in Visual FoxPro: * Start of Code

SET EXCLUSIVE OFF

USE test

FOR i=1 TO 100000 INSERT INTO test (name,m1) VALUES (&quot;Junk&quot;, &quot;This is some data for a test&quot;)

ENDFOR

 Run the following code to create a table that is named test: CREATE TABLE Test (name C(10), m1 m)  Build an executable from the code that you created in step 1. Save the executable on a computer that is running Windows Millennium Edition or an earlier version of Windows. Create a share on that computer, and then connect the computer that is running Windows XP to the share. Start the executable on the computer that you created the share on, and then start it from the computer that is running Windows XP. You may receive the error message that is described in the &quot;Symptoms&quot; section.
 * End of Code </li>

Keywords: kbcodesnippet kbprb KB812696

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.