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!Help Needed: Trouble Filtering and Re-Entering Data
Hi everyone, I'm looking for some help. I've started working on something quite simple, but I can't get it to function correctly. Yep, total noob moment. The concept is straightforward, and I've attached what I’ve started so far. The idea is to paste multi-line text into a text field. For example: [12:29] 1g Name Bundle sib 03 03F : 1g Name Bundle sib 03 03F Gender: Female Coat: Black Walker Eye: Garnet Mane: Long Tail: Long Coat Gloom Hair Gloom Skull Branding Wing Style: Pegasus Wing Color: Nightfall bae515d4-1caa-cda5-c259-b2d436f3ba19 Here’s what I’m trying to achieve: The first line ([12:29] ...) should be filtered out. The name should be extracted: 1g Name Bundle sib 03 03F The UUID (last line) must be unique—no duplicate entries allowed. If the entry has already been added (based on the UUID), it shouldn't be accepted again. However, if the input is deleted, it should be possible to re-enter it, but currently, it still says the data has already been entered, even after deletion. Could someone please check and help me figure out what’s going wrong? Thanks in advance!
