topic Re: Microsoft Access DB in Data Warehouse

Microsoft Access DB

aputhuraya — Sun, 28 Jul 2024 03:33:13 GMT

Hi,

While playing around with Fabric, I am wondering if an MS Access DB application can perform DML and DQL queries on:

1) Fabric Warehouse Table

2) Fabric Lakehouse Table

The end goal is for the user to have an interactive UI to be able to "manipulate" data, not just view it.

Thanks!

Re: Microsoft Access DB

AndyDDC — Sun, 28 Jul 2024 10:42:58 GMT

Not with a Lakehouse as the SQLEndpoint is read only.

You could try with an "azure sql" tutorial and modify for use with a Warehouse endpoint, I'm not sure how authentication will work as Fabric Warehouse only support azure Active Directory (entra) and service principals. Also Warehouse may not support system tables that Access requires.

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

Re: Microsoft Access DB

Anonymous — Tue, 06 Aug 2024 08:32:56 GMT

HI aputhuraya,

I'd like to suggest you take a look at the following document which show the compare table between products and supported features.

What is data warehousing in Microsoft Fabric? - Microsoft Fabric | Microsoft Learn

Regards,

Xiaoxin Sheng