D
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/
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/