469,150 Members | 1,995 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,150 developers. It's quick & easy.

access 2007 memo field error


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.

Jun 28 '15 #1
1 1091
2,321 Expert Mod 2GB
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?
Jun 28 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by toufik | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.