Forum Discussion
Microsoft Access DB
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 f...
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.