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?