Access 2003 append query truncates memo fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What the #%$@^. I have two identical databases, residing
at different locations. When I 'merged' the two by
appending one to the other, all appended memo fields
became truncated to 255 char.

I then had to run an update query to correct this. Since
when is this a feature of Access?? This append query was
NOT a Totals query.

Thanks a bunch,
Laurel
 
Hi Laurel

Post the SQL used for the append query.

It did not have a GROUP BY clause, but did it contain DISTINCT or
DISTINCTROW?

How was the append query executed? Through the interface? Via code, using
the Execute method of the DAO or ADO libraries? Using linked tables?
 
Allen, thank you for responding.

I can no longer replicate this error. I can tell you this: the SQL is
just an Insert Into statement with no Distinct in there at all. I ran
the query manually. The tables resided in the same db as the query.

I will re-post this if it occurs again, and pursue it further.

Laurel
 
Back
Top