I am spearheading an Access database build of hundreds of documents that I was planning on setting up the backend on SharePoint that we would need to purchase. As I do research in the SharePoint, I'm seeing issues after issues with the Access/SharePoint relationship which has me wondering is it worth it and what other options we have?
We are a small non-profit and have Office 365 service where the OneDrive is more than enough for our document storage. My sole purpose for possibly getting SharePoint for our members have easy access to the records in the Access database since we can only store Access files in the OneDrive. Currently we can only move the file to and from the OneDrive to the computer and that can take several minutes at a time and potentially allow data to be lost or over written.
I understand there are other servers I can use but I am concern with cost and the protection of personal information in the files. It sounds like what I read (on the internet) that Microsoft is moving away from the Access/Sharepoint relationship, and if they are, what is their planned alternative or am I over thinking the issues and should proceed with SharePoint