We operate a small retail business with three retail shops. Each shop has it's own PC running Windows 10 and Office 2016 (we subscribe to Office 365 Home edition). We have created a customer ordering database in Access 2016 and now wish all three shops to have access to this (add records etc) We have tried splitting the database and putting the backend on OneDrive and providing the other two with the front end. Whilst this works perfectly for the shop that split the database it is not available to the other two. Can this be done on OneDrive or should we be looking at something like SharePoint?
See Question&Answers more detail:os