Microsoft KB Archive/235391

Knowledge Base

ACC97: Concurrent Appends to a Memo Field Can Cause Corruption and Produces the #deleted Symbol

Article ID: 235391

Article Last Modified on 1/24/2007

---

APPLIES TO

• Microsoft Access 97 Standard Edition, when used with:
  • Microsoft Windows NT 4.0

---

This article was previously published under Q235391

SYMPTOMS

Data corruption can occur when concurrently appending data from multiple instances of Microsoft Access to the end of a Memo field. Once corrupted, the field displays a #deleted symbol and further attempts to access the field will produce the following error:

The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.

Repairing the database incorrectly reports that it completed successfully. Compacting the database yields the following message:

Record(s) can't be read; no read permission on 'filename'.

Data in other fields within the table and record are unaffected. The row can be deleted, removing the corruption successfully.

RESOLUTION

To resolve this issue, obtain Jet35sp3.exe (Microsoft Jet 3.5 Service Pack 3). To obtain Jet35sp3.exe, please see the following article in the Microsoft Knowledge Base:

172733 Updated Version of Microsoft Jet 3.5 Available for Download

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem no longer occurs in Jet35sp3.exe (Microsoft Jet 3.5 Service Pack 3).

Additional query words: records can t be read

Keywords: kbhotfixserver kbqfe kbbug kbfix kbqfe KB235391

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.