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?
Try creating a user DSN instead. I prefer them anyway, since you don't need that DSN on client machines when you deploy.