Database Corruption: Concurrent Appends to a Memo Field

Memo fields are used by user when there is a need of saving large amount of text in the database. Access uses a pointer to another location for the data in large fields (memo, hyperlink, or OLE Object). If the pointer is written incorrectly, the field displays garbage.

But when the database is over the network then the concurrent appending to the memo fields can lead to corruption of data. Once corrupted, the field displays a #deleted symbol and further attempts to access the field you may get following errors:

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

Or

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

If the strange characters appear only in the query, not in the table, this is not a corruption. This occurs when JET database is unable to determine the data type of the query field, and is triggered by lots of situations. In this situation you must install latest jet hot fix service pack which can download from Microsoft’s site. This jet compact utility repairs your database.

If this is a corruption issue then you can resolve this kind of corruption, you can delete memo field from your table. Then create the memo field again. You can old import old data using (File > Get External> External Data >Import ), create a query joining the current and older copy on the primary key, and then change it to an Update query to update the blank memo field with the contents of the old one.

Still you are getting this error and all the above option are worthless then it leads that your database is critically corrupted. In this scenario you need access repair software. These software are the applications that are designed to repair the lost or damaged database. It is very easy to use and available with different brand names and prices.

Stellar Phoenix Access Recovery is the most powerful and the best ever made Access data recovery software. This access database repair software can be used by user without having any technical knowledge. This Access recovery software has an intuitive and simple user interface. This access recovery software can be used to repair and restore all of the database components including tables, queries, forms and reports.