Fx ODBC issue where column name of 64 characters is 1 too many
When the Linked Table Manager sees a column name in a SQL Server table with 64 characters, it only uses the first 63 characters of that column name.
After linking, an attempt to view table data will fail, with the message
"[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name "'123456789012345678901234567890123456789012345678901234567890123'."
The column name in my table on SQL Server is:
So Linked Table manager is truncating that for some reason.
There is a 64 character limit for object names.
I cannot find any documentation anywhere saying there is such a limit of 63 characters in ODBC linked tables.
Same issue with ODBC v17 (v17.3) as well as ODBC v13.
The version of SQL Server is SQL Server 2017, on Windows 10 Pro. The version of MS Access is from Office 365, (Access Version 1903), and is installed on the same Windows 10 Pro instance as the SQL Server is using. For the Linked Table manager, my results are the same whether using the Windows Integration authentication as the SQL Server (login) authentication.
Stephen Gornick commented
Another user has confirmed the behavior as I reported it.