Type conversion failure in memo field update

I have an update query I run in an Access 2003 application to allow users to update notes in a separate database.  I have to do this due to user permission issues in the main database.  That DB is SqlServer 2005 and I have linked the tables into access.  I have a form that allows the user to edit an original note and then update it in a temp table.  The temp table then updates the live table in the SqlServer Database.

It has worked fine over the years, but there is now the need for a note entry that is larger than had been normally entered.  It seems that if the original note is 8000 characters or more, I now get an error stating that Access didn't update the field due to type conversion failure.  I know the temp table field is a Memo field that should be able to hold 65k characters, and I know the field in the SqlServer Table is Text.  As there is no Memo field type in SqlServer, I am confident this is the appropriate type for that DB.

I have tried several tests and can find nothing that would stick out to an intermediate as myself.

Does anyone have any ideas?

Thanks