(First off, apologies if this is the wrong forum ... I wasn't sure if this belonged in "Excel Programming / VBA / Macros" or "Access VBA" or "Office 365")
I'm currently using a macro-enabled spreadsheet to manipulate an Access DB which is stored on a network (not cloud) server, accessible within our company's internal network. (The spreadsheet is based on Denis Wright's excellent tutorial, located at http://www.datawright.com.au/excel_r...ss_and_ado.htm). Overall, this has worked well, although some of my users have complained that it doesn't work when they're working remotely.
In order to get around this, I'd like to try and move the .accdb file to our company's Office 365 location, but the issue I'm running into is that the path to the Office 365 folder is something like this: C:\Users\MyUserName\OneDrive - CompanyName ... obviously, since this has my username in the path, it won't work for any other user. Does anyone know what the correct path to the Office 365 folder would be? Is it even possible to use Office 365 in this manner?
Here's the code I'm using to connect to my DB file
And here is the data from B24 and B25 which is referenced
B24: |
\\server\data\shared\RelDB |
B25: |
ReleaseDatabase.accdb |
Bookmarks