SQL Server nvarchar(max) fields are truncated (1 Viewer)

valeryk2000 said:

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

Click to expand...

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.

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