[AccessD] Memo field is truncated

Using the ALL keyword should take care of it:  SELECT ALL FROM ... Etc.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, February 10, 2009 12:53 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Memo field is truncated

I've seen this discussed many times, but I can't remember the solution
-- a reader's Make Table query is truncating a Memo field to 255
characters. I've found a few things on the kb, but nothing that seems to
be the exact thing I'm looking for -- nothing for Make Table anyway.
I've sent links to the few articles that are close.

Does anyone remember what this is -- off the top of your head?

Susan H. 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com