Access 2003 excceding memo field

[dschl]

Hi All,

I'm experiencing a most interesting error message in Access 2003. I
have two tables with the same exact design. When I run an insert query,
I get a field size/paste error.

What gives?

The insert query is quite simple:
insert into table2 select DISTINCT table1.* from table1

Now, when I remove the DISTINCT, the query works as expected.

This sure looks like an MS bug. Is there a workaround, other than
removing the DISTINCT?

-Dave
http://www.dgs-services.com/

 

[Douglas J. Steele]

AFAIK, you can't use DISTINCT with Memo fields. This is because DISTINCT
requires that a sort be done, to ensure no duplicates, and you can't sort on
Memo fields.