Cannot create linked tables in Access for Office 365

0
votes

I have an Access database on Office 365 and I need to create linked tables to Azure SQL database. "Linked Table Manager" is greyed out, so I tried going to External data -> ODBC database and selecting option "Link to data source by creating a linked table". Then I proceed to create an ODBC connection which does not seem to show up in Access even though it gets created on my machine. Can anyone help me diagnose an issue or point me in the right direction?

1
ms-accessoffice365linked-tables
Once you have created a working DSN, use it to create the linked table. - Patrick Honorez
That's the thing - I have a working ODBC connection but cannot access it from Access. No pun intended - Coding Duchess
What kind of DSN is it (user, system...) ? - Patrick Honorez
As a workaround, you can also create a passthru query, set the proper ODBC Connect Str and write your SELECT. This way, no DSN used. - Patrick Honorez
try creating a user dsn instead. - Patrick Honorez

1 Answers

0
votes

Try creating a user DSN instead. I prefer them anyway, since you don't need that DSN on client machines when you deploy.