Hi everyone,
I'm trying to share a database with my collegues.
At the moment I have one single .ACCDB file which contains tables, queries, forms and reports.
We've been sharing this .ACCDB file on OneDrive, and 4 collegues occasionally open it to read or edit the database using the main form.
I know this is a really bad practice: infact, whenever two of us try to edit the database at the same moment, OneDrive creates another copy of the file and the edits cannot be merged.
Since the number of users that have to access this database is increasing over time, I need to find a way to properly share the database online.
I've watched this video that is really well made:
It is clear to me that I'll have to split the database into a backend and a frontend, but I'm still trying to figure out which is the best platform where to migrate the tables.
I've tryed successfully with SharePoint (converting the table in SharePoint Lists on my organization SharePoint website), but the database becomes really slow, especially for heavier tasks, so I'm trying to find another solution.
Regarding Microsoft Dataverse or SQL Server, would I get better performance than SharePoint? If with SharePoint the process was pretty simple, I really don't know where to start in order to setup a SQL Server online...
Thank you in advance