Forum Discussion
Why the Dataverse connector?
I take that back. I actually have two accdbs linked to Dataverse tables in two different Solutions.
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.
- "I was told that SP Lists and DV can't be used as data sources for Access"
That is flat out inaccurate.
We've been using SharePoint lists with Access since at least 2003. Access Web Databases, released in Access 2007, used ONLY SharePoint lists. In other words, the exact opposite is true. SharePoint lists work just fine. And so do Dataverse tables.
It may well be that Dataverse is too demanding for your needs, though. That's different from "can't be used".- What VBA code are you using to get SP lists to work? I would show you a screen shot but I am on a windows 11 that doesn't support screen captures.
- What do you mean by that question? Linked SharePoint lists are similar to local Access tables. One need not actually run any VBA code to use them. What kinds of things do not work in your environment? Please be specific.