Open Microsoft Access file directly from Onedrive?

Is it possible for Access to open a file straight from Onedrive, like Word can? I have attached an example screenshot of the way Im trying to open it.
When I try to do that, it thinks about it for a few seconds, then comes up with a message that says "The file does not exist, or you do not have read access to the file".

example.png
I have tried it on two computers and both did the same thing. If you do the same process to open a document in Word, it works just fine.
It will open if I browse to a copy of the file saved locally.

Im thinking maybe Access just doesn't support open files straight from Onedrive? I was hoping to avoid having a copy saved locally because the Onedrive account that is linked with Office is different to the Onedrive account linked to the computer and you cant sync two personal Onedrive accounts at the same time.
Luke Van EedeAsked:
Who is Participating?
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.

JohnBusiness Consultant (Owner)Commented:
It is usually a bad idea to open a database file like Access or QuickBooks over the Internet (On Drive). You can damage the database that way.

Use a local file, or on a Local Area Network.

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
Luke Van EedeAuthor Commented:
Yeah, I thought that might be the case, but I would still like to know for sure if it is possible. It gives you the option, so it looks like it should work, but maybe they don't allow it for the reason John just said.
JohnBusiness Consultant (Owner)Commented:
I would still like to know for sure if it is possible   <-- It can work (so there is no article that says it cannot work) but you can damage the database  (numerous article support this).
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Daniel PineaultPresident / Owner CARDA Consultants Inc.Commented:
Shared online drives are not compatible with Access, see http://www.devhut.net/2016/09/24/access-back-end-location-wan-online-server-onedrive-dropbox/ to learn more about some options that exist.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
As John has said, you can't use One Drive with Access.

Jim.
Luke Van EedeAuthor Commented:
Ok, thanks for the info. I will just have to use a local copy of the file then.
JohnBusiness Consultant (Owner)Commented:
You are very welcome and I was happy to help
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.