Hi there. Access newbie here - please excuse my lack of technical knowledge; any reply to me may need to be written as though I'm a five year old
We have an Access database that two of us now use (one up until this week). A button on it links to files kept in a OneDrive which is synchronised to the company's SharePoint. Currently it has the file path (specific identifier details removed through parentheses) "C:\Users\[MyColleaguesName]\[OurOrganisationName]\[SharedDriveName] - [NameOfFolder]" (i.e. C:\Users\RonaldMcDonald\McDonalds\BigMacDrive - DriveThruRota for example).
Obviously, when I click the button, the link is broken as it's linking to my colleague's computer files.
Does anyone know if there's a way either to link directly to the files on SharePoint or writing the file path so that it searches any user's OneDrives?
Many thanks.