Forum Discussion
Why the Dataverse connector?
I am not sure why your .accdb link works when mine doesn't. Are you sharing these front-end Access files with other users? Or are you just using for your own private database? In any case, I am having an awful experience using SharePoint lists for Access. One of the SP lists does not sync up to Access while the others do. No rhyme or reason for this when I used the same process for the other tables. (I rebuilt all 5 tables in SharePoint and then connected them in Access). All the Sp lists were imported / connected to Access and they all sync up but one. My takeaway is that SP won't work for my purposes. And it appears that Dataverse won't either. Microsoft cobbled SP and DV together from 1980's technology, trying to patch it into today's modern SaaS & SaaP environments. It just does not work well.
- What I mean by sync is that the sharepoint list is not updated from the respective Access form. As for the 1980's tech, I meant to say 1990's tech. I have coded websites from the ground up. From this perspective, SharePoint sites are lacking the basics of modern website features, especially when it comes to file and document management. The inability to customize where SPLists are uploaded is one example of lackluster design. Anyway, I'm moving on. I have the budget to build an SQL server. But I do appreciate your input.
What does it mean to say "one of the SP lists does not sync up to Access"? Please elaborate on what you do see. "Synch up" is not a commonly used term in this context, so before trying to guess what your problem is, we ought to know exactly what you are experiencing.
"Microsoft cobbled SP and DV together from 1980's technology"
Really? Do you honestly believe that SharePoint and Dataverse predate the internet and Windows? It's statements like that which make it increasingly difficult to lend credence to other claims.