Does Microsoft Access linked tables support connections to SQL Server on Azure VMs as well as Azure SQL Database?

Question

The following method is basically about how to connect from Microsoft Access to an on-premises SQL Server, but can Microsoft Access running on the client PC connect to the SQL Server instance on the Azure VM that the client PC is connected to?

https://learn.microsoft.com/en-us/sql/ssma/access/connect-to-sql-server-accesstosql?view=sql-server-ver16

I checked the following documentation and it was about Azure SQL Database.

https://learn.microsoft.com/en-us/sql/ssma/access/linking-access-applications-to-sql-server-azure-sql-db-accesstosql?view=sql-server-ver16

If there is a way to connect to SQL Server on Azure VM using Microsoft Access linked table, I would appreciate it if you could let me know.

Answer 1

If you SQL Server instance is in an Azure VM, that is no different from an on-prem SQL Server instance.