Memo field gets truncated in MS Access Query

[ksbigfoot]

I have linked tables from MS Access 2000 to SQL Server.
The field I am looking at is a Memo field on MS Access side and linked to a Text 16 field on SQL Server side. All the data is there when I look at the linked table, but as soon as I do a query, the data gets truncated down to 255 characters. Is there a way around performing a query and not losing this data before populating maybe another temporary table?
Thanks

 

[SteveR77]

If your memo field is formatted this link may help you.

http://support.microsoft.com/default.aspx?scid=kb;en-us;259893&Product=acc

Steve

 

[ksbigfoot]

Hi SteveR77,
No, I am not applying any formatting to the memo field I don't think.
There is a group by applied to it. Do you think this could cause the truncation?

 

[SteveR77]

I am guess that it could be the link from the SQL side and Access seeing textbox from the SQL limiting the viewable data to 255 based on the textbox limit, but still actually having the full amount of data in the field.

Let me see what else I can find for you on this one.

Steve

 

[jmcclain]

I've run into this problem in the past. Supposedly this is a limitation of the jet engine.

I thought this only happens though when you perform an aggregate function on the memo field.

Are you doing any grouping or trying to select distinct?

 

[ksbigfoot]

Hi mmcclain,
I am doing a group by.
Weird thing is that I have a form in MS Access that displays all the characters (550 characters) when it pulls from the memo field, but when I try to write a query it truncates the value.

 

[ksbigfoot]

I removed the group by and my query returns all the characters of the memo field.
I will have to look at my logic to see about getting rid of the group by for all the queries that use memo fields.
Thanks for your help SteveR77 & jmcclain