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...
Hi,
Thanks for the clarification as I was told the wrong information by an Access user. I am very familiar with SharePoint lists and have a basic understanding of Dataverse. I found the GUI and workflow for the latter very clunky. My organization is a non-profit so there is no budget for the resources to support an SQL backend. The database I am building is for a small team - about 30 or less users. I don't think I will have more than 10 tables and less than 3,000 records, so SharePoint lists should do the trick.
Thanks for your response.
Thanks for the clarification as I was told the wrong information by an Access user. I am very familiar with SharePoint lists and have a basic understanding of Dataverse. I found the GUI and workflow for the latter very clunky. My organization is a non-profit so there is no budget for the resources to support an SQL backend. The database I am building is for a small team - about 30 or less users. I don't think I will have more than 10 tables and less than 3,000 records, so SharePoint lists should do the trick.
Thanks for your response.
SQL Server Express is free, if you have a way to install it. A cheap Windows hosting site that would support a SQL Server database could be as little as $5 -- $8 a month US. A SQL Azure database would be in that same price range.