Trouble linking a SQL Server varchar field to memo field

[TerryDASNY]

Hello,

I am linking a SQL Server view that has a varchar (500) field containing a comment. When I link this view to MS Access, the varchar field converts to a text (255) and truncates the data. I tried modifing the data type in the linked view in Access to a memo data type, but Access will not allow me to change properties on a linked table or view. Is there a way to link a large varchar field (500 characters)in SQL Server to a MS Access memo field?

 

[lupins46]

Varchar does not match to memo; varchar matches to text and so the incompatibility is that SQL varchar can have 8000(?) characters and Access text can only have 255.
SQLServer Text fields convert to Access memo fields.

Don't blame me - take it up with Billy G.

 

[TerryDASNY]

Thanks for your suggestions lupins46. I changed the SQL Server data type for that field to text ntext and nchar relinked the view each time and all of those SQL Server data types converted to Access data type of text (255). I still wind up with my truncated comment field. Bummer.

 

[lupins46]

Can't explain that.
I've just run a test here and got memo fileds in Access when linking to Text fields in SQL Server.

Don't know what to suggest.

 

[TerryDASNY]

Thanks again lupins46. I did get your suggestion to work once I changed the data type of the field in the view to a type of ntext(CAST(Comments as ntext)). Initially I was changing the Comments field data type in the table that was the data source for the view I was linking to MS Access. Once I changed the field in the view it worked like a charm. Thanks again for your help. You helped make a couple of users very happy in our organization.