I am connecting to SQL Server using ODBC 18 (have also tried 17)
and when I link a table, any records with non English characters in them make the entire row display every field as #DELETED

HOWEVER, if I IMPORT the same table into Access, then it displays everything fine.

I presume there is some form of Collation/Character encoding issue within the connection itself, but I cannot find anything to change.

FYI the columns in SQL Server are NVARCHAR and the database is using the Latin1_General_CI_AS collation.

Can anyone point me in the right direction to resolve this please?

Tried ODBC 17 & 18.
Looked through the connection wizard for any possible criteria to change