locked
Link Access to Shared Excel file in One Drive for Busines RRS feed

  • Question

  • Hello,

    I have an Excel file in One Drive for Business that I have shared with two others. The only way I have found to link it to Access is by Syncing my to my desktop. My question is how do I get the others who open the Access database on their desktops to also have a link to my shared Excel file since the link is mapped to my C:\Users\One Drive account. Since these two users are in the same O365 site collection will they automatically connect after signing in?

    Thanks in advance!


    John Fletcher

    Thursday, June 30, 2016 1:37 AM

Answers

  • Fundamentally the path to the excel file (where ever it may be) must be the same for each user

    I can't say whether or not with One Drive that would be the case.  One would think not - off hand....but try it and see.  Since you've posted this I assume it does not work but I would be interested to know if you find that it does.

    An alternative to what you want to do is set up the link to an excel file in the local Public folder.  Everyone has this.  Then you'll need to instruct them that before opening Access each time to manually copy/paste the One Drive excel into their Public Folder.  It's not ideal but not a lot of work....and will definitely work.

    Caution however this is for read only as any updates to the excel would not be shared.

    A more elaborate solution is with a 365 Account where one can link to tables in a 365 share point list.

    Saturday, July 2, 2016 1:17 PM

All replies

  • >>>My question is how do I get the others who open the Access database on their desktops to also have a link to my shared Excel file since the link is mapped to my C:\Users\One Drive account. Since these two users are in the same O365 site collection will they automatically connect after signing in?

    According to your description, you could use OneDrive as your centralized storage solution for all forms of data, and then access that content seamlessly from your PC, even when you’re offline. So you might create and edit an Excel file on your PC, and then you can read or edit that document on your phone or tablet while commuting to work, on the web from your work PC, or in any other situation you might imagine. You could refer about OneDrive Tip: Use Documents and Other Libraries with OneDrive

    Please correct me if I have any misunderstandings on your question.

    In addition could you provide more information about issue, do you have any error or exception? Screenshot is best, more detail information will help us reproduce and resolve it.

    Thanks for your understanding. 
    Friday, July 1, 2016 5:18 AM
  • Fundamentally the path to the excel file (where ever it may be) must be the same for each user

    I can't say whether or not with One Drive that would be the case.  One would think not - off hand....but try it and see.  Since you've posted this I assume it does not work but I would be interested to know if you find that it does.

    An alternative to what you want to do is set up the link to an excel file in the local Public folder.  Everyone has this.  Then you'll need to instruct them that before opening Access each time to manually copy/paste the One Drive excel into their Public Folder.  It's not ideal but not a lot of work....and will definitely work.

    Caution however this is for read only as any updates to the excel would not be shared.

    A more elaborate solution is with a 365 Account where one can link to tables in a 365 share point list.

    Saturday, July 2, 2016 1:17 PM