I currently have a split MS Access database completed on my local machine. It has BE and FE tables with user log in. The database is currently stored on my local machine in a MS Onedrive folder. I have a MS sharepoint account also set up. (company accounts). I need to 1. Configure the MS Database so that users can log in via MS Access on their local machine and update the data, to be stored on MS Sharepoint lists. 2. The connection needs to either be live or refreshed each time data is added into the MA Access database. 3. The Sharepoint list will need to sync with the MS Access database. Note: The database is not large, it has 18 tables with relationships. I need assistance with execution and explanation on how to configure it.
Hi there, The easiest way to do this is, directly link the Sharepoint tables in your FE. This needs some optimization as well. But this has some lack. Let's discuss on chat in detail. Thanks, Rayyan