Our organization is in the process of upgrading their technology infrastructure. They would like to eliminate shared file server files and move everyone to Microsoft OneDrive for file storage and sharing.
I've been asked to test the Access databases I've developed in this environment.
From what I can see and have read, including Microsoft's documentation, Access cannot function in OneDrive. Unlike other MS Office programs like Word and Excel, OneDrive does not even offer an ability to
open an Access file that is in OneDrive cloud, only to download. I'm guessing that an Access file that is local to one's PC can be "Synced" with OneDrive cloud. Our IT manager want's to test sharing the database with each user, having them do their updating
locally and rely on the syncing to One Drive cloud to apply each user's updates. I think this will result in multiple versions of the Access file being synced to the OneDrive cloud but no one version will have everyone's updates. I could envision sharing a
front end this way, but not the back end (all our databases are split). All databases are currently Access 2010.
Ultimately the goal is to put everyone in the organization on Chromebooks/boxes, using Office365 in the cloud and with all data in OneDrive cloud.
I would be interested, therefore, in perspectives on OneDrive for Access and other alternatives for cloud based Access deployment. I've read in Microsoft articles that they suggest using PowerApps in Office
365 going forward as an alternative to Access, so any information on that would also be appreciated.
This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.
No you cannot store an Access database in One Drive. Don't even try. The only way something like that will work is if you can check out the file, work on it locally, while all other users are blocked out, then check it back in.
There are some alternatives. You can use a Citrix box that users can log into.. You can also use an Azure or SQL Server back end for your data with a local Access front end. But there may be a performance hit. Power Apps is an alternative for data gathering,
but its still not quite at the level of an Access front end with VBA automation.
Hope this helps, Scott<> Blog: http://scottgem.wordpress.com Microsoft Access MVP since 2007
2 people were helped by this reply
Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.