ACC97: Concurrent Appends to a Memo Field Can Cause Corruption and Produces the #deleted Symbol (235391)
The information in this article applies to:
- Microsoft Access 97, when used with:
- the operating system: Microsoft Windows NT
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
STATUSMicrosoft 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).
| Modification Type: | Minor | Last Reviewed: | 9/22/2005 |
|---|
| Keywords: | kbHotfixServer kbQFE kbbug kbfix kbQFE KB235391 |
|---|
|