J
John
I'm trying to append memo fields from one table to
another. Both fields involved are memo fields. I'm using
an append query and Access is truncating the fields in the
results table at the 255th character as if it was a text
field. I tried a make table and got the same thing. I
tested this out with the Northwind database, importing my
source table and creating the queries and destination
table there and it worked. So it must be some setup
setting that's done in Northwind that I don't have in
mine. Anybody know what it might be. I ended up copying
the Northwind database and deleting all of the objects,
replacing them with the ones from my database and it
works, I just don't know why and would like to for my own
knowledge. Any tips would be appreciated.
Thanks,
John
another. Both fields involved are memo fields. I'm using
an append query and Access is truncating the fields in the
results table at the 255th character as if it was a text
field. I tried a make table and got the same thing. I
tested this out with the Northwind database, importing my
source table and creating the queries and destination
table there and it worked. So it must be some setup
setting that's done in Northwind that I don't have in
mine. Anybody know what it might be. I ended up copying
the Northwind database and deleting all of the objects,
replacing them with the ones from my database and it
works, I just don't know why and would like to for my own
knowledge. Any tips would be appreciated.
Thanks,
John