We help IT Professionals succeed at work.

Access Database multiple users on onedrive

LillyC
LillyC asked
on
155 Views
Last Modified: 2018-11-14
My client would like to share with multiple users their Access Database on onedrive.

Is this possible, if so does anyone have a good link I could read this up on?
Comment
Watch Question

CERTIFIED EXPERT

Commented:
Possible yes, workable no.

Look at migrating the database to SQL or Azure DB instead.
CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
LillyCDatabase Developer

Author

Commented:
Thank you both
CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
You are welcome!
Mike LazarusAct! Evangelist - CRM Consultant
CERTIFIED EXPERT

Commented:
As has been pointed out, no. The reason is that OneDrive copies the latest version of the entire file, not just records changed.

The last two options on this page might be options for you: Ways to share an Access database

Note: The Sharepoint option now is only available for On-Premises Sharepoint

Depending on the application, you might also consider PowerApps
LillyCDatabase Developer

Author

Commented:
Thanks for this additional info Mike, I'll take a look at the options.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions