[AccessD] Rich Text Field Data from Azure Not Showing

[David Emerson]

Thanks to the help of this group (especially Paul, Stuart and Jim) we solved the problem.  The solution was to upgrade to version 18 of the OLE DB Driver and use “Provider=MSOLEDBSQL” in the connection string.

 

Regards,  David

 

From: Paul Hartland [mailto:paul.hartland at googlemail.com] 
Sent: Friday, 26 June 2020 8:51 a.m.
To: David Emerson
Subject: Re: [AccessD] Rich Text Field Data from Azure Not Showing

 

This looks like it may be a common problem done a bit of googling not sure if tgis is the same as the link I sent you earlier - https://social.technet.microsoft.com/Forums/security/en-US/eac97768-c388-4b37-8868-829ca4297bfd/nvarcharmax-not-working-with-ado-and-odbc-drivers-other-than-sql-server?forum=sqldataaccess

 

Paul