MS Access & OneDrive

We use OneDrive for company files and we have recently added our ms access db to it. the problem with this is it creates copies of the database if someone opens it at the same time. Is there a way around this or convert it using the new Access 2016 to an online version?

Thanks
LVL 1
QuarmAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
No.  One Drive simply won't work with an Access database.   neither will Dropbox or other such type sites.

You need a windows server with a file share for multiple users.

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
and I should add, not over the internet.

Access won't work over a WAN (well very, very few - just high end point to point's).

Jim.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Also, there is no such beast as "an online version" as of now. You can use other resources, like Citrix/RDS or www.eqldata.com, but that's about it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.