Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
aputhuraya
Frequent Visitor

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 for the user to have an interactive UI to be able to "manipulate" data, not just view it.

 

Thanks!

2 REPLIES 2
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
AndyDDC
Super User
Super User

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-se...

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

JanFabricDW_carousel

Fabric Monthly Update - January 2025

Unlock the latest Fabric Data Warehouse upgrades!