Truncation of an SQL memo field

[AdrianHC]

I have an access database, 2000, linked to SQL tables.

The primary SQL table includes some memo fields.

When I open the table in access, the memo fields are shown in full but when I include that field in a query the field is truncated to 255 characters.

The query selects all the fields from the main table and adds other information from other tables.

I have tried using a query to make a local copy of the table but the same truncation occurs.

As it happens with more than one record, I have dismissed the possibility of a rogue character in the original table.

Does anyone know the reason for the trunaction and a solution/work-around?

Thanks

[NeoPa]

I'd only be guessing (I never need to use Memo fields), but have you tried processing through your data with a recordset.

DAO is the default, but try both. I expect ADODB is the more likely to handle it without truncation.

[missinglinq]

Allen Browne has an article that explains the causes for this phenomenon and gives some workarounds as well:

http://allenbrowne.com/ser-63.html

Welcome to Bytes!

Linq ;0)>

[NeoPa]

Thanks Linq.

I was struggling there ;-D