Linked Table Memo field 8000 char max

[okerix]

Hello,
Kind of run into a weird issue. I am trying to create some saved imports for some users to import excel spreadsheets into a table. The setup is MS SQL 2008 backend with Access 2007 frontend. So on the backend the field is a varchar(MAX) and on the frontend access displays it as Memo. One particuliar row has that field filled in with around 10,000 characters. When I try the import every row makes it in except for that one. After cutting the field down to 7,930 it went in just fine. So I deleted it all and reimported again this time without the problematic 10,000 char result. Then I went into the backend and added the 10,000 char result to the correct row with no problems and even Access shows it just fine. Any idea why Access is limiting my imports to 8,000 char?
Thanks,
Shaun

 

[DCrake]

What type of data is in the field, just text I assume? It may be that the actual weight of the text is over its 64k limit, don't know for sure.

 

[okerix]

Yes it's really just a bunch of text. The only odd characters in it are some bullet points but I removed those and that didnt change a thing. How could I test my text weight? Just paste into notepad and save it?

 

[pkstormy]

Try changing it to a TEXT (or nText) type field on SQL Server 2008 versus a Varchar(MAX). I believe a TEXT type field in SQL Server still represents a Memo type field in MSAccess which allows more characters than Varchar(MAX).

 

[okerix]

Alright thanks a bunch that worked perfectly. See I thought they were doing away with the text field and doing variables like varchar(MAX). I know the inital maximum for a varchar is 8000 chars but the MAX is suppose to really surpass that I thought. Is this a bug in the functionality that access automatically puts a 8000 char limit on the field?