access 2007 memo field error

[cristosjulian]

Hi

Access 2007 memo field corruption

I am currently supporting a Access database. The database has a Access 2007 Front end which in saved on the desk top for multiple users and the backend sits on an Access 2007 database on the office server (Dell Xeon 490). Users input and view records in the form on a tracker and data table.

The problem field is a memo field and we know users sometimes incorrectly try to access the same record at the same time and if done in normal circumstances they will be locked out from this record.

However recently we have has “#Error” values appearing on the memo field and therefore the system is loosing the data. Anyone else had similar problems with Access 2007 and know the exact cause of this error and recommend any actions to prevent this? This also just affects the same memo field each time. The significance of this memo field is text from the internet is copied on the field and saved in Access 2007 database.

I would be grateful if anyone could provide some guidance on this issue. I am not sure if recent server slowdown and performance issues is contributing to this error occurring on an access DB.

Thanks

[TheSmileyCoder]

Hi cristosjulian, welcome to Bytes

Are you using rich text or plain text in the memo field? If the field is rich text, it could be that the text you are copying has html markup that confuses access.

Other than that, I can't really say I've had any issues with memo fields and 2007. There are certain general errors that can occur when you use expressions on memo fields in a query, such as field truncation, and in some cases (I think its when you do a sort on a memo field) you can run into some edge cases. Then again, its not likely you would want to sort on a memo field.

Is your form based directly on the table, or on a query?

How much data per record are we talking about? How much data (length of characters) are you copying in?