Using MS Access on OneDrive

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.

Thanks
This process isn't recommended and I don't think it will even work.

Here's some answers provided previously on the same question:

https://answers.microsoft.com/en-us/onedrive/fo...

https://answers.microsoft.com/en-us/msoffice/fo...

And here is info from Microsoft on ways to share:

https://support.office.com/en-us/article/ways-t...

1 person was 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.

How satisfied are you with this response?

Thanks for your feedback.

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.

How satisfied are you with this response?

Thanks for your feedback.

Take a look at using SharePoint instead of OneDrive:
https://www.youtube.com/watch?v=NoPomdqVKBY

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.

How satisfied are you with this response?

Thanks for your feedback.

This youtube gives you an overview of sharepoint:
https://www.youtube.com/watch?v=TE9TpraPlrE

9 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.

How satisfied are you with this response?

Thanks for your feedback.

 
 

Question Info


Last updated September 19, 2020 Views 21,611 Applies to: