[AccessD] Nvarchar(max)

Gustav Brock gustav at cactus.dk
Thu Jul 1 07:16:05 CDT 2021


Hi Anita

Could you please provide as much info as possible to reproduce this issue - Access version/build etc?
A (link to) demo/sample would, of course, be perfect though probably difficult for you to provide.

I've reported your findings to the team, but they can't reproduce it:

---
I setup a table in SQL Server with a nVarChar(Max) column, linked that table to Access using the ODBC Driver 17 for SQL Server and then created a multiple items form for that table but I'm not seeing an issue. I've tried working with strings less than 8000 characters and over 8000. Please provide any further specifics to get this to reproduce or share a reproduction sample for us to test.
---

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD <accessd-bounces+gustav=cactus.dk at databaseadvisors.com> På vegne af Anita Smith
Sendt: 1. juli 2021 13:11
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: [AccessD] Nvarchar(max)

Hi Group,

Just a short note to let you know that I have spent most of the day troubleshooting an application that have been in use for well over a year that has suddenly stopped working in one area.

After a lengthy process of elimination I have worked out that using nvarchar(max) fields on continuous forms have stopped working (the screen would freeze and throw an ODBC query timeout error).

There must have been an update in the last week to have caused this as the app on site and my old development app here both encountered the same issue. I also found the same issue in various versions of ODBC as well as various versions of SQL Server- yes, I really have been through the wringer today, trying everything under and over the sun.

Anyhow, change the field to something else and the problem is solved.

Beam me up Scotty!

Anita


 
Anita Smith 

M: 0402 022 462
E: anita at ddisolutions.com.au

Custom Software, Databases and Websites 


More information about the AccessD mailing list