Hi,
Hoping someone can help me out.
Within my access database I have a linked table to a SQL Server. I have setup the ODBC connection and the table link works no problem, except is missing random columns. I've also tried other table from the SQL server and they are also missing columns. They are not hidden and they are not restricted data type fields (hyperlink, /etc) The linked tables are well under the 255 max, some only have 10 columns.
Now, If I create a pass through query within access to the same server and table I can then see all the columns.
I can see all of the columns using the same connection string is SSMS and PowerBI and even in Excel.
Does anyone have any idea / suggestions why some of the columns are not visible ?
Appreciate any help
Thanks
Hoping someone can help me out.
Within my access database I have a linked table to a SQL Server. I have setup the ODBC connection and the table link works no problem, except is missing random columns. I've also tried other table from the SQL server and they are also missing columns. They are not hidden and they are not restricted data type fields (hyperlink, /etc) The linked tables are well under the 255 max, some only have 10 columns.
Now, If I create a pass through query within access to the same server and table I can then see all the columns.
I can see all of the columns using the same connection string is SSMS and PowerBI and even in Excel.
Does anyone have any idea / suggestions why some of the columns are not visible ?
Appreciate any help
Thanks