Article ID: 237333 - View products that this article applies to.
This article was previously published under Q237333
This article has been archived. It is offered "as is" and will no longer be updated.
Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
After you edit a Memo field in a Microsoft Access database, "#Deleted" appears in the field, and the original information is lost.
If you try to use the "Compact and Repair Database" utility on the database, the field may have several number signs in it, as the follows:
Multiple instances of Microsoft Access are editing the Memo field at the same time. This behavior commonly occurs in an environment where multiple users are using the same shared database on a network.
Retype the information in the field. If necessary, retrieve the missing information from a backup copy of the database.
To avoid this behavior, you can implement row-level locking in the database. To do so, follow these steps:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.
Steps to Reproduce Behavior
For more information about record-level locking, click Microsoft Access Help on the Help menu, type record locking in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.