Append Query truncates data posted to a table memo field

Append Query truncates data posted to a table memo field

Post by TGV3aXMgT » Sun, 11 Feb 2007 02:04:01


I use a query is to create a new record in a table with values taken from
unbound controls on a form. Using an append query truncates data that is to
be posted in the table to a memo field.

I have defined the security of the user with the task of creating a new
record so that this user does not have the right to update an existing
record. Given these security restrictions, what routine can I use to create
a new row in my table without truncating the data to be posted in a memo
field?
 
 
 

Append Query truncates data posted to a table memo field

Post by Allen Brow » Sun, 11 Feb 2007 10:12:03

The SELECT part of your query must be performaing some kind of aggregation
on the memo field.

See:
Truncation of Memo fields
at:
http://www.yqcomputer.com/

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://www.yqcomputer.com/
Reply to group, rather than allenbrowne at mvps dot org.

 
 
 

Append Query truncates data posted to a table memo field

Post by TGV3aXMgT » Thu, 15 Feb 2007 04:35:03

Thank you, Allen. I am looking over your tips to see which one relates to my
problem.