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

EFS 0 Reputation points
2024-04-22T17:41:46.8033333+00:00

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.

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
308 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
822 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,145 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 13,436 Reputation points Microsoft Employee
    2024-04-23T05:30:18.2566667+00:00

    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.

    0 comments