910 questions
It works now. Thanks
Access using ODBC to SQL server where tables are longer than 64 characters.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 28.000000000000004%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESW%3C/text%3E%3C/svg%3E)
Shmuli Wenger
1
Reputation point
I am using the SQL ODBC to connect SQL server to an access database. My issue is that the tables names are longer than 64 characters so Access won't link them. I found a forum online where someone posted this question and the answer given was to create a view for each table on the SQL server and then Access will link these views like Tables. The forum was locked so i couldn't respond but i was able to create the view in the SQL but in Access when i open the ODBC to that server it only shows me the tables and not the views as mentioned in the forum.
Thanks
Sam
Microsoft 365 and Office | Access | Development
{count} votes
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2022-09-14T20:58:41.293+00:00 I would recommend that you add a tag for Access to your post. From the SQL Server side of things, I can't say why Access only shows you table.
-
Shmuli Wenger 1 Reputation point
2022-09-15T00:29:20.693+00:00 Thanks I added that tag
-
Viorel 122.6K Reputation points2022-09-15T08:25:37.323+00:00 The method seems to work.
Maybe try creating a new ODBC connection, specify the default database, and check it in a new Access file.
Sign in to comment