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

Memo fields are used by user when there is a need of saving large amount of text in the database. They can store up to 1 gigabyte of characters of which 65,535 characters can be displayed and you can also do rich-text formatting to the data in a Memo field like you can set colors to the text.

But when the database is over the network then the concurrent appending to the memo fields can lead to corruption of data. You can do only one concurrent append to a file on multiple workstations at a time. Once the data is corrupted in these mdb files then the field displays a #deleted symbol. Further access to the same database will generate 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".

When you try to repair the database with compact repair utility tool a wrong message is displayed that it has been repaired successfully but in reality it is not so as when you compact it further another message displays:

"Record(s) can’t be read; no read permission on ‘filename’."

The reason behind this is that when multiple appending is done to any database they are not identified and hence the data gets corrupted.

To solve this problem Microsoft has suggested obtaining Jet35sp3.exe (Microsoft Jet 3.5 Service Pack 3) file. But sometimes it may happen that after obtaining this file too your database still remains in corrupted form. The corrupted data may create a big problem as these mob files may contain several relevant information’s.

To come up from this condition various access repair software are available which are able to repair these mdb files and restore them. These software scan all your corrupted files and repair them.

Stellar Phoenix Access Recovery software is one of the leading software which provides this solution. This software is secure and easy to use and provides you an interactive interface to work upon. All the file versions of MS Access are supported by this software including Access 97, 2000, 2002/XP, 2003 and 2007. Its demo version provides you an overview of all the files which can be repaired and after using it you can store as per your suitability.