I cannot see any tables when Connecting the Azure via MS Access Linked Table Manager, what am I missing?

Question

I have installed AdventureWorksLT as well as my own tables in a new Azure database that I am trying to connect to via "Linked Table Manager" in MS Access but all I see are the sys tables. If I use DoCmd.TransferDatabase acLink it works fine but I would like to use the Linked Table Manager instead and its just not working. I have used the ODBC connection string provided by Azure, by Access, and nothing will show the SalesLT schema. I have created a Login and User (with the same name) and given them db_datawriter roles and used that user in the Connection string as well as the SA user, but nothing appears in the window of tables available for linking. I made the user's default schema AdevntureWorksLT, still nothing. If anything is jumping out at you as to why this isn't appearing please let me know.

Answer 1

Hi EFSAdmin,

Welcome to Microsoft Q&A forum.

As I understand, you are unable to see tables from MS Access to Azure DB.

Could you please refer to the MS official documentation with the prerequisites, steps for Link to or import data from an Azure SQL Server Database:

https://support.microsoft.com/en-us/office/link-to-or-import-data-from-an-azure-sql-server-database-88c0cc2c-21dd-46f5-b74a-0db3613f5166

Make sure network settings are correct at your end and authentication is done as mentioned in the documentation.

Also try updating Access to the latest version and retry if works.

You could also try https://docs.devart.com/odbc/sqlazure/access.htm where connection of MS Access to SQL Azure Using an ODBC Driver is given.

Let us know at what step you face issue, thanks.