Google Drive or Sharepoint - mapped drive on server - is it possible? How?

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?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jamie McAllister MVPSharePoint ConsultantCommented:
With Office 365 you have synchronization capabilities in SharePoint and in OneDrive. You could certainly sync the SharePoint library between a file location and O365.

What's a little unconventional is syncing the contents from a server folder. Usually users sync to their local device. (I guess to go about this you'd grant an O365 subscription to a service account on the server, but that seems like a hack).

I think this is the wrong way to go about it.

I'd investigate whether the Access application can be made to create the folder direct in a SharePoint library. Access can certainly connect to and manipulate Library information directly. Then users will be able to access the library directly from a variety of devices to see the information.

Create the folders in O365, not on your server.
Rob4077Author Commented:
Thanks for your comment. As a result of your suggestion, this question has now been opened out to MS Access (MS Office) area to see if anyone can help me figure out how to create folders and open a window to display the contents of a folder directly in a SharePoint library instead of the server.
Jamie McAllister MVPSharePoint ConsultantCommented:
I would suggest you map the library as a drive and configure access to use that path.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rob4077Author Commented:
How do I map the library as a drive?
Rob4077Author Commented:
Thanks for your comments that has lead me to a workable solution.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.