Update Query - Record is too large

[scgoodman]

I am trying to update (2) fields from a temp table to a master table. Both fields are defined as memo, with unicode compression as No. I tried it as Yes as well but get the same error 'record is too large'. Do you have any suggestions to try?

I checked the field lengths on characters for the (2) fields and there is nothing over 255.

Thanks
Shannon

 

[jdraw]

Please show your table structures.

If the field is less than 255 characters, why are you using Memo?