MS Access & Sharepoint limitations
Hey everyone, I've got a topic I'd like to discuss that relates to my MS Access database. The situation is that I need to make it accessible remotely for multiple people scattered across Europe. Now, I know there are two options I can explore: Splitting the current database into two files, the Front End (FE) and Back End (BE). I'd store the BE file in the cloud and keep the FE file on my local machine. Rewriting the whole thing in SQL and storing it in MS SQL or something similar. My main focus right now is on the first option. But here's where I need your help: If I want to store the BE file in SharePoint, do you know if it can be done with SharePoint Online or if I need SharePoint Server? And how do I go about setting it up so that the local files stay connected to the backend at all times? My ideal scenario is to have multiple people with their own FE files, and any changes they make should update the BE in real time. I've spent ages searching for answers and even talked to support, but I just end up confusing myself more each time. I'm really looking for straightforward information rather than opinions. If any of you have any insights or can lend a hand, I'd greatly appreciate it. Thanks!