Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Q and A _ Can I Link Photos Stored On Office 365 (onedrive, Sharepoint, Etc.) With An Access Database?

Posted by: Plaxerous Aug 14 2019, 11:48 AM

We have a database that generates reports with pictures that are pulled from a network drive. However, the pictures are not available if the user becomes disconnected from the network drive when working from home or traveling.

We recently integrated with Office 365 so is there anyway we could store the photos on SharePoint or OneDrive, and have the database pull from there? The easiest way from the user perspective would be to store the photos locally on their computer, and create a shareable link which can be copy/pasted into the database, but shareable links do not seem to be .jpg or image files.

Any advice is appreciated! Thanks!

Posted by: theDBguy Aug 14 2019, 11:55 AM

Hi. Welcome to UA! welcome2UA.gif

https://www.access-programmers.co.UK/forums/showthread.php?t=306337, but I'll give the same response. Hope you find a better answer here or there. Cheers!

Posted by: GroverParkGeorge Aug 14 2019, 12:05 PM

I do use OneDrive for two 100% personal use databases where I have total control over links and URLs. It's pretty performant for a single user. Well, my brother and I both have the accdb and links to the OneDrive folder.

I don't know how that would translate to multi-users. We're very low volume.



On my PC, I have a mapped drive "O:\" for my OneDrive.


==================

I currently have about 4,940 image files in that OneDrive, which occupies about 9 GB of space.