Dude... where'd my data go?

[hartMS2007]

I am working with MS Access 2007 using a front-end / back-end setup. the back-end contains the tables... front-end contains, you know, reports, queries, forms, a little VB (etc.).

Frequently, memo fields in the database table are truncated to 255... I had the opportunity to review and follow the the helpful tips from allenbrowne.com/ser-63.html but to no avail.

It is almost occuring randomly or possibly after a sequence of actions database table memo fields are truncated.

The bulk of my Googling searches show results for trucation on export/output viewing reports etc. NOT necessarily the actual database table(s).

Any thoughts appreciated.

Cheers,
Paul

 

[boblarson]

Not sure if the article states what I know is that if any criteria is in any query that deals with the memo fields and that criteria is anything but Is Null or Is Not Null, then you need to build a separate query with all fields EXCEPT that memo field and have the criteria in that query and then you do up a second query with the original table put in again and joined by the key field(s) and then the memo field added there. That will solve about 90% of your memo field truncation issues.