Forum Discussion
Dataverse or Sharepoint list for Access
I am developing an Access DB and looking at using either SharePoint list or Dataverse tables as the data table sources. I was told that no remote data source is suitable for Access. I find this somew...
I fully agree that SharePoint lists are not optimal for a relational database application. I remain curious about the specific problem you encountered.
With regard to Dataverse, I have to sort of agree and disagree. The disagreement part is considering it "beta". I think it's past that point although the whole environment is still very new and not well understood by many Access developers. If you have a choice, it is not the preferred option for Access developers yet. There is one positive to note about Dataverse, and that it the ability to support offline synching. In a situation where some part of data entry must be done via a mobile device, such as an inventory in a warehouse, the ability to continue working without a wireless connection can be very useful.
However, absent that "mobile hybrid" aspect, there isn't yet enough known about Dataverse, in my opinion, to make it a choice over Azure SQL or a hosted SQL Server database.
I guess I mostly want to avoid blanket dismissal of most options because there are always specific situations where that unique set of features makes one of those options really attractive.
With regard to Dataverse, I have to sort of agree and disagree. The disagreement part is considering it "beta". I think it's past that point although the whole environment is still very new and not well understood by many Access developers. If you have a choice, it is not the preferred option for Access developers yet. There is one positive to note about Dataverse, and that it the ability to support offline synching. In a situation where some part of data entry must be done via a mobile device, such as an inventory in a warehouse, the ability to continue working without a wireless connection can be very useful.
However, absent that "mobile hybrid" aspect, there isn't yet enough known about Dataverse, in my opinion, to make it a choice over Azure SQL or a hosted SQL Server database.
I guess I mostly want to avoid blanket dismissal of most options because there are always specific situations where that unique set of features makes one of those options really attractive.
I connected Access to an existing SharePoint list which seemed to introduce the duplication errors. I deleted all the duplicate records and that seems to be working. Although that may have done the trick, I am not confident it won't happen again, hence my hesitation to use SP lists or Dataverse, I don't know if these MS cloud data sources are reliable or not for Access. Although, I am not expert in SQL server, I will see if my organization will consider purchasing an SQl cloud service. Any suggestions on that?
Thanks
Thanks