Access Database Migration to Azure SQL DB fails

Hi @Stephan Hölzer,

Thanks for contacting to Microsoft QA.

It looks like you're running into a common issue when trying to connect Microsoft Access to an Azure SQL Database using ODBC. The error you're seeing—about referencing master.sysdatabases—is expected behavior in Azure SQL.

Unlike traditional SQL Server, Azure SQL is a cloud-based service (PaaS), and it works a bit differently. It doesn’t give direct access to system databases like master, model, or msdb, which Access sometimes tries to query behind the scenes. That’s why you’re getting the error—it’s trying to reach something that Azure SQL doesn’t allow.

Set Up Your ODBC Connection Properly

• When configuring your ODBC connection, make sure you’re pointing to your actual Azure SQL database—not the default or master database.
• In Access, double-check that you’re selecting the correct schema (like dbo or any custom schema you’ve created). Avoid choosing “master” or “default” as those won’t work in Azure SQL.

Check Your DSN Settings

• Ensure your Data Source Name (DSN) includes the correct server name, database name, and authentication method.
• The database name should match the one you’re working with—not the system default.

Use the Right ODBC Driver

• If you haven’t already, install the latest version of the https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server. Some users find better compatibility with version 17.

Try SSMS or Azure Data Studio

• If Access continues to give you trouble, try connecting to your Azure SQL Database using

https://learn.microsoft.com/en-us/sql/ssms/sql-server-management-studio-ssms

or https://learn.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio.

These tools can help confirm that your tables and schema are set up correctly.

Your patience and understanding are truly appreciated.

Thanks,
Vrishabh

Hi @Stephan Hölzer,

May I kindly ask if the solution we provided earlier was helpful for you? Please let us know if you need any further assistance—we’d be happy to assist you.

Thanks,
Vrishabh

Hi @Stephan Hölzer,

Just checking if the steps provided above have resolved your concern, or if you need any further assistance.

Thanks,
Vrishabh