Linking Access to SharePoint folder (1 Viewer)

Harris@Z

Registered User.
Local time
Today, 23:23
Joined
Oct 28, 2019
Messages
42
Hi, I wonder if this is possible and if someone can advise?

My database generates pdf reports to a folder that syncs through OneDrive to a SharePoint folder. On SharePoint, the pdf is electronically signed and moved to a second folder, where it is synced back to a second folder on OneDrive. From there, Access sends the electronically signed report to a client.

Is it possible to programmatically link Access to the SharePoint folder directly to save, delete, and move files between SharePoint folders instead of via OneDrive?
I have searched extensively and cannot find a solution which suggests either my search terms are wrong, or it cannot be done.

Any advise will be welcome.

Regards
Harris
 

theDBguy

I’m here to help
Staff member
Local time
Today, 13:23
Joined
Oct 29, 2018
Messages
19,210
Hi. I was also going to say you might look into using SharePoint to do the job. Another example is possibly by using Workflows.
 

Harris@Z

Registered User.
Local time
Today, 23:23
Joined
Oct 28, 2019
Messages
42
Thank you both for your input. I was not aware of SharePoint REST. Very foreign to me, and appears to be outside my level of understanding as an average programmer, but will explore further and see if I can learn enough to get this working!
 

Users who are viewing this thread

Top Bottom