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

Azuki 0 Reputation points
2023-12-05T14:41:36.46+00:00

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.

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 106.5K Reputation points
    2023-12-05T22:31:05.77+00:00

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

    0 comments No comments