I hope this is the right place to post this...

I'm using a DataTable to ACCESS 2007 which works quite well. However it's update TableAdapter is truncating the data at 640 characters.

Is this normal?

If so, is there a work around?

here's the standard SQL update statment I'm using. "Summary" is the memo field which holds a lot characters.

UPDATE Library
SET Type = ?, Unit = ?, CreateDate=?, LastRevised=?, ApprovedBy=?, Title = ?, Purpose = ?, Scope = ?, ownerFname = ?, ownerLname =?, Author = ?, Prerequisites = ?, Summary = ?, GettingHelp = ?, Definitions = ?, [Link-to-CoverPage] = ?, Resides = ?
WHERE (ID = ?)

thanks... Lee