Forum Discussion

Rexter's avatar
Rexter
Brass Contributor
Sep 07, 2023

Why the Dataverse connector?

Can anyone explain to me why Microsoft added a Dataverse connector to Access when you can't share an Access DB using Dataverse tables? I would love to know the logic on that piece. 
access
George_Hepworth's avatar
George_Hepworth
Silver Contributor
Sep 08, 2023

George_Hepworth 

 

I take that back. I actually have two accdbs linked to Dataverse tables in two different Solutions.

 

 

Rexter's avatar
Rexter
Brass Contributor
Sep 08, 2023

I have not found and way to export Access tables to a Solution. I tried several times and the tables only export to my environment. I am thinking you have a different subscription than I do. My organization has a 365 Business Premium sub, but apparently, we need an Enterprise sub for full SharePoint & Dataverse capabilities. No budget for that. I tried using Sharepoint lists as a temporary measure, but I am having the same issues. Appearently, Access Combo box won't write to a SP List of Davaverse. So, I ask again, what is both connectors? 

 

I was told that SP Lists and DV can't be used as data sources for Access. Now I clearly see that they were correct. Hoping I get budget approval for an SQL server soon. In any case, dataverse is a far too a complicated platform. It requires heavy IT support. I am an Access developer, not an IT engineer - not suitable for non-IT developers.