Microsoft Access database running off the cloud storage like Microsoft OneDrive

 I have Microsoft Access databases running off  the file server. For internal users, they run directly from their desktop shortcuts. For external users like sales people, they log into our terminal server and run from their RDP session.
 This requires a login for external/sales people and they don't like that.
 They like to be able to run Access database like they are opening Word or Excel files from their Microsoft OneDrive.
 I like to know if anyone has run Microsoft Access databases successfully off the OneDrive(I am not talking about microsoft Azure which is essentially a file server in the cloud)?
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.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
One Drive, Drop Box etc all don't work because they are a file sharing service, not disk storage in the typical sense.  Besides which unless the app is designed for it, performance would be dismal.

The setup you have at the moment is the best.  However with a newer version of RDP or Citrix, they could access the app in a web browser or as a shortcut on their desktop (it's still an RDP session).

 The only other option is:

Beyond that, converting to a SQL Server back end would help, then you'd just need a hosted server somewhere.   But again, the app really needs to be designed from the ground up for client/server to get good usability.


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
sgleeAuthor Commented: ---> Interesting. Have you personally used their service?
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
I have not, but a few EE members have and reported that it worked as exactly as advertised.

One had a few issues with their apps, but nothing beyond the issues you would have getting it to work on terminal services.

Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Jeffrey CoachmanMIS LiasonCommented:
FWIW, company tried a trail of it and it worked well.

Then only thing was the Cost per seat was a bit high for us...

But since MS does not have a direct path to the web for established databases, ...
This product is great in that you don't have to change anything.

Jim can probably tell you more though....
sgleeAuthor Commented:
Thanks for the information and I agree that it is pretty hefty pricing structure.
But still good to know that such service is available.
Dale FyeOwner, Developing Solutions LLCCommented:
Although I think the Terminal Server method is preferred, at least at the moment, Microsoft is now offering another option called Azure Remote Apps.

This is a fee based service which allows you to run your Office applications in the cloud, from virtually any device.
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 Access

From novice to tech pro — start learning today.