X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Can I Link Photos Stored On Office 365 (onedrive, Sharepoint, Etc.) With An Access Database?, Any Version    
post Aug 14 2019, 11:48 AM

Posts: 1
Joined: 14-August 19

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!
Go to the top of the page
post Aug 14 2019, 11:55 AM

UA Moderator
Posts: 78,635
Joined: 19-June 07
From: SunnySandyEggo

Hi. Welcome to UA! welcome2UA.gif

Crossposted here, but I'll give the same response. Hope you find a better answer here or there. Cheers!

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
post Aug 14 2019, 12:05 PM

UA Admin
Posts: 37,639
Joined: 20-June 02
From: Newcastle, WA

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.

Attached File  GeorgeInaHat.PNG ( 911.41K )Number of downloads: 7

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.

This post has been edited by GroverParkGeorge: Aug 14 2019, 12:12 PM

My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    7th August 2020 - 07:44 PM