Query with Memo field

[Homer]

I'm trying to run a query which includes a table with a Memo field.

Query won't even run but giving me this error:

"The field is too small to accept the amount of data you attemted to add.
Try inserting or pasting less data"

If I remove the memo field from the query it works fine.

How can I make it work? I can't change the memo field to text as then it's
too short.

Access 2002
Thanks

 

[David Lloyd]

The following KB article deals with a similar issue to the one you are
seeing.

http://support.microsoft.com/default.aspx?scid=kb;en-us;896950

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I'm trying to run a query which includes a table with a Memo field.

Query won't even run but giving me this error:

"The field is too small to accept the amount of data you attemted to add.
Try inserting or pasting less data"

If I remove the memo field from the query it works fine.

How can I make it work? I can't change the memo field to text as then it's
too short.

Access 2002
Thanks