Our office uses a MS Access program to handle various management functions including creation of a folder on the server for each job where various related docs related to that job are saved. This means when we are looking at a record in the database we can open the related folder with the press of a button.
We now have a need to make these created folders available to remote users via iPad. It seems that the easiest way to do that would be to load these folders in Google Drive, DropBox or Sharepoint (Our email accounts are handled through Office 365 that provides a sizeable Sharepoint facility). However we need to retain the ability for the MS Access program to create the folders so that means we would need to have the Synced folder reside on the server and a mapped drive. That way MS Access can create the folder on the server, as it does now, and that would be synced with the cloud making it available to remote users.
Is this possible and if so, how do I set it up?