SQL Server nvarchar(max) fields are truncated

[mdlueck]

But ... try to link you SQL Server table to Access and see - the varchar(max) field is truncated...

Ohhhh... Then I am glad I avoided completely Linked Tables in my application!

I saw them as a security risk.

My application makes use of all Stored Procedures to obtain access to the SQL BE DB, and when needing to populate a FE temp table, then I download the record(s) to the FE temp table and bind Access Forms to the Access FE temp tables through DAO.QueryDef objects... which are dynamically created on-the-fly.

 

[valeryk2000]

Guys, I found the solution (probably just for SS2K8 and earlier versions) - I changed datatype from nvarchar(max) to text - and now everything works ok.
Thank you for having fun with me!
Val